if statement problem

[Guest]

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?

 

[Don Guillett]

If they are numbers, take out the " " and try again

 

[Guest]

THIS DID NOT WORK. ANY OTHER IDEAS?

If they are numbers, take out the " " and try again

 

[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)

 

[Don Guillett]

You YELLED at me. Now I'm going to my room to cry.