Can't make Excel "if" Formula work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is my formula: =IF(b5=0 0 d5). What is wrong with it? I cannot get
past messages that there is something amiss.
 
=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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Zero Formula 6
Difficult Formula 9
Automatically add lines and keep formulas 2
Need formula 1
Conditional formatting comparing times 12
how do I create a nonadjacent series for autofill to go by? 3
IF formula not working 6
Conditional Fromatting and Formulas 5

Back
Top