| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can I use IF statement with a formula?
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. |
|
#2
|
|||
|
|||
|
=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") -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Michael NYC" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statement formula | Excel Discussion (Misc queries) | |||
| if statement | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
Hybrid Mode
