What is wrong with this formula?

  • Thread starter Thread starter StompS
  • Start date Start date
S

StompS

I have been having problems calculating formulas with the IRR function
(that's another story). I just tried to do a simple IF functin and am still
getting a formula error.

=IF(F11>0,F11*.44,"$0")

(error highlights "0,F11")

F11 is formatted as currency with symbol "$" selected in the currency symbol
box. What am I missing?

Thank you.
 
Try this one:
=IF(F11>0,F11*.44,"$0")
I just replaced the "," with ";"

I worked here.
 
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

sumproduct with three criteria 8
Excel Excel Formula - IF Function with percentages 1
Summary Sheet Returning #value! 1
Sum of minutes and seconds times price? 2
Creating one formula for use in two different cells 2
What's Wrong With This Formula? 12
error #DIV/0! 7
How do I limit formula results to positive only? 4

Back
Top