Can I use IF statement with a formula?

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

Guest

I am trying to create a condtiona statement that permits me to process and
equation if the value is true. For example:

=IF(D20="Yes","(D11*E20*D4)","NA")

But can't get it to work. I appreciate any help.
 
=IF(D20="Yes","(D11*E20*D4)","NA")

Remove the double quotes (and the parens as well)
from: .. "(D11*E20*D4)" ... , viz, try:

=IF(D20="Yes",D11*E20*D4,"NA")
 

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

Payment calculation 1
Calling name of Sheet as a Variable? 1
Principal & Interest Formula 1
nested if statements using "AND" as well as "OR" 2
If statements 2
Excel Formula Formatting - How to Add a STOP Statement 4
Help with IF and VLookup Match Statement 1
Formula help please!! IF(OR 2

Back
Top