Hi
I know this is incredibly easy but for some reason i havent been able to crack it
I need help with an IF formula that multiplies depending on the value in a cell
example
A1 - 5.5
If(A1<3.33,1.1*A1,IF(A1 is between 3.34 - 4.47,1.2*A1,IF(A1 is between 4.48 - 6.6,1.3*A1,IF(A1>6.7,1.5*A1)
Couldnt get a formula to work properly for numerous "between" numbers
Hope that all makes sense
Bookmarks