Hi,Not sure if this is possible...I'm looking to create a formula that checks the condition of a single select cell called {Alt Shop}. IF empty use {Discount Code} if it contains "Shop Name" to use data from a particular cell in a particular row.For ...
Hi,
Is there ANY solution to adding numbers separated by commas in the same cell?
I have used the SUBSTITUTE function to replace multi-select items with a numerical value and this has resulted in this kind of result:
3,2,1,4,1
Now I need to add those...
Hi,
This is my current formula for an If not blank > do this OR if blank > do this:
IF({Discount}, {Brand} & " Discount Code: " & {Discount} &" off -",
IF(NOT(Discount), {Brand}))& " "&{Product Title}
But I would like to add another option that if {...
I am trying to format decimals in a formula to no avail:
To the left is the numberthe 3rd column is what happens when this number is used in a formula (the end is cut off for numbers ending in 0) (e.g. 12.50 > £12.5middle column is where I have form...
Hi,
I am using this formula and it isn’t implementing the decimal places from my {Refill / lowest price} column, which in itself is set to 2 decimal places:
"Lowest cost per " & {Unit} & " based on: " & “£” & {Refill / lowest price} & " for "& {Lowes...
Thanks Kamille, this is great!
I also need to apply the same rule for "FREE TRIAL for “FREE SAMPLE”, how might I add that to the mix, please?
Thank you!
Adam, you’re a star, it works! I was choosing to either use the ROUND function OR your formula, but I realised it requires both:
Left column is amount formatted with:
ROUND({PRICE PER}, 2)
Right column is your formula applied using the above alrea...
Thank you so much! That worked! :grinning_face_with_big_eyes:
I have used the same formula in another area, and wondered if you could help with this too please?
middle is formatted number using:
ROUND({PRICE PER}, 2)
But once in a another formula ...
