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.