Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More than one IF Statement
I want to do the following: IF H8="Yes" then the sum in G8, IF H8="Yes" AND
J8="Yes" then G8 + I8. However, if J8 is blank then it only adds G8. |
#2
|
|||
|
|||
=IF(AND(H8="YES",J8="YES"),G8+I8,G8)
I think this should work..will you have answers other than YES and blank? "heater" wrote: I want to do the following: IF H8="Yes" then the sum in G8, IF H8="Yes" AND J8="Yes" then G8 + I8. However, if J8 is blank then it only adds G8. |
#3
|
|||
|
|||
One way:
=G8*(H8="yes")+I8*(J8="yes")*(H8="yes") or a little shorter: =(H8="yes")*(G8+I8*(J8="yes")) HTH Jason Atlanta, GA -----Original Message----- I want to do the following: IF H8="Yes" then the sum in G8, IF H8="Yes" AND J8="Yes" then G8 + I8. However, if J8 is blank then it only adds G8. . |
#4
|
|||
|
|||
This will return the value in G8 if H8 does not
equal "yes". HTH Jason Atlanta, GA -----Original Message----- =IF(AND(H8="YES",J8="YES"),G8+I8,G8) I think this should work..will you have answers other than YES and blank? "heater" wrote: I want to do the following: IF H8="Yes" then the sum in G8, IF H8="Yes" AND J8="Yes" then G8 + I8. However, if J8 is blank then it only adds G8. . |
#5
|
|||
|
|||
It worked! Thanks
"JEV" wrote: =IF(AND(H8="YES",J8="YES"),G8+I8,G8) I think this should work..will you have answers other than YES and blank? "heater" wrote: I want to do the following: IF H8="Yes" then the sum in G8, IF H8="Yes" AND J8="Yes" then G8 + I8. However, if J8 is blank then it only adds G8. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |