Multiple IF

[loscherland]

I need a formula to calculate the margin price dependant on the RRP a
follows:

IF RRP is between 29 - 99, then margin is 50
IF RRP is between 100 - 199, then margin is 60
IF RRP is 200+, then margin is 70

How do I write an IF formula for this

 

[Andy B]

Hi

Try this:

=IF(A2>=200,70,IF(A2>=100,60,IF(A2>=29,50,"none")))

 

[Frank Kabel]

Hi
if this value is stored in A1 try
=IF(A1>=200,70,IF(A1>=100,60,IF(A1>=29,50,"not defined")))