Been trying to get this working for a little while but quite new to formulas. What i need is
if A1 is less than 2 B1 should show 4, if A1 is between 2-3 B1 should be 6, if A1 is between 3-4 B1 should be 8, if A1 is between 4-5 B1 should be 10 and if a1 id greater than 5 then B1 should show A1 x 2
I am not sure if i have been searching the wrong terms but have been unable to find and answers.
“It”? you mean that A1 should be all these values based on A1 itself? or do you need that result in some different cell?
sorry, yes the answer would be in a separate cell and all be based o the value of A1.
=IF(A1<2;4;IF(A1<3;6;IF(A1<4;8;IF(A1<=5;10;A1*2))))
I took the liberty to decide which should be < and which <= - please tweak as required.
Brilliant thanks. That is exactly what i needed. i think i wasn’t too far off but using commas instead of semi colons and i was trying to include the higher number which i see now was not necessary.
Whether you can use comma as parameter separator depends on your settings based on your locale, however semicolon works in all locales (and then for display may get converted to comma again in your settings) that’s why we prefer to use semicolon here for formula expression examples.