How to, "If ......then" etc

[JAYLOTT]

Hi,

Want to reference a particular cell withinin a formula and say

if < 20 then 5%, if >20 but <30 then 4%, if >30 then 3%

any idea how to do that ?

Thanks in advance

[Trebor76]

Hi there,

Let me know if the following does the trick (change the A1 cell reference to suit):

=IF(A1<20,5%,IF(AND(A1>20,A1<30),4%,3%))

HTH

Robert

[VBA Noob]

Or

=LOOKUP(A1,{1,20,30},{"5%","4%","3%"})

VBA Noob

[JAYLOTT]

Thanks Guys, worked perfectly