Cassy_Amelia - profile

Cassy_Amelia · May 18, 2023

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 ...

Cassy_Amelia · Oct 27, 2022

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...

Cassy_Amelia · Jun 20, 2022

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 {...

Cassy_Amelia · Jun 18, 2022

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...

Cassy_Amelia · Jun 14, 2022

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...

Cassy_Amelia · Oct 27, 2022

Hi, Can this formula be amended for removing multiple commas, e.g: 1,1,1,3,1 to create a sum of 7 Thank you!

Cassy_Amelia · Jun 21, 2022

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!

Cassy_Amelia · Jun 20, 2022

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...

Cassy_Amelia · Jun 19, 2022

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 ...

Cassy_Amelia · Jun 15, 2022

Side note: here is a clearer view of the formula result:

User Statistics

User Activity

Formula IF statement pulls data from a specific row + cell

SUM of values separated by commas in the same cell ,

IF, ELSE, OR in Formulas

HELP! Formatting Decimals in Formulas

Decimal places being removed in formula + Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date

Re: SUM of Values separated by a comma in the same sheet

Re: IF, ELSE, OR in Formulas

Re: HELP! Formatting Decimals in Formulas

Re: HELP! Formatting Decimals in Formulas

Re: Decimal places being removed in formula + Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date