View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default Can't make Excel "if" Formula work

=IF(B5=0,0,D5)

Or, if you have European settings,

=IF(B5=0;0;D5)

What do you see if you enter this formula? Why do you think it is wrong?

--
Kind regards,

Niek Otten

"Janie Ellen" <Janie wrote in message
...
This is my formula: =IF(b5=0 0 d5). What is wrong with it? I cannot get
past messages that there is something amiss.