if statement problem
 

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?

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

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
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?

THIS DID NOT WORK. ANY OTHER IDEAS?

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
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?

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


"ermeko" wrote in message
...
THIS DID NOT WORK. ANY OTHER IDEAS?

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
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?

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

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
THIS DID NOT WORK. ANY OTHER IDEAS?

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"ermeko" wrote in message
...
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?