View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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?