# answer based on cell contents

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.