Can I use IF statement with a formula?

M

Michael NYC

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.
 
M

Max

=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")
 
Top