Multiple IF

L

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
 
F

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")))
 
L

loscherland

Sound lads, that worked -- Really need to do a refresher course o
excel!!! -- Can't remember anything
 
Top