if statement problem

E

ermeko

hi,
I need an if formula like
b1=if(a1="14,50","10,50",if(a1="14,00","10,00",if(a1="13,50","18","0")))
but this formula does not work.
can anybody help me?
 
P

Peo Sjoblom

=IF(A1=14.5,10.5,IF(A1=14,10,IF(A1=13.5,18,0)))

if they are numbers (change to comma if you are not using English regional
settings)
If that doesn't work then there is simply a mismatch and you have to check
your data
and please don't use all caps, it's considered rude

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top