This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
