Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then else conditions
Someone helped me with this previously, and I accidentally cleared the
information (and the location of the post) from my computer. Ugh! I'd appreciate help once again, and I promise not to lose it this time. I need an If Then Else statement to combine the following: If E 0, then H2-E2 If E2=0 and F2=0, then H2-D2 THANKS! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then else conditions
=IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2),"")
What about E2 = 0, F2 < 0 E2 <0? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Someone helped me with this previously, and I accidentally cleared the information (and the location of the post) from my computer. Ugh! I'd appreciate help once again, and I promise not to lose it this time. I need an If Then Else statement to combine the following: If E 0, then H2-E2 If E2=0 and F2=0, then H2-D2 THANKS! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then else conditions
Thanks...we're almost there! When I input your formula, it tells me there are
too many arguments for this function. If I use it without the final set ofd quotation marks, it inserts FALSE in the cells where F2 has a value. I need it to be blank any time F has a value. "Bob Phillips" wrote: =IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2),"") What about E2 = 0, F2 < 0 E2 <0? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Someone helped me with this previously, and I accidentally cleared the information (and the location of the post) from my computer. Ugh! I'd appreciate help once again, and I promise not to lose it this time. I need an If Then Else statement to combine the following: If E 0, then H2-E2 If E2=0 and F2=0, then H2-D2 THANKS! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then else conditions
Bracket in wrong place
=IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2,"")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Thanks...we're almost there! When I input your formula, it tells me there are too many arguments for this function. If I use it without the final set ofd quotation marks, it inserts FALSE in the cells where F2 has a value. I need it to be blank any time F has a value. "Bob Phillips" wrote: =IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2),"") What about E2 = 0, F2 < 0 E2 <0? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Someone helped me with this previously, and I accidentally cleared the information (and the location of the post) from my computer. Ugh! I'd appreciate help once again, and I promise not to lose it this time. I need an If Then Else statement to combine the following: If E 0, then H2-E2 If E2=0 and F2=0, then H2-D2 THANKS! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then else conditions
Perfect! MANY thanks!
"Bob Phillips" wrote: Bracket in wrong place =IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2,"")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Thanks...we're almost there! When I input your formula, it tells me there are too many arguments for this function. If I use it without the final set ofd quotation marks, it inserts FALSE in the cells where F2 has a value. I need it to be blank any time F has a value. "Bob Phillips" wrote: =IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2),"") What about E2 = 0, F2 < 0 E2 <0? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "wrosie" wrote in message ... Someone helped me with this previously, and I accidentally cleared the information (and the location of the post) from my computer. Ugh! I'd appreciate help once again, and I promise not to lose it this time. I need an If Then Else statement to combine the following: If E 0, then H2-E2 If E2=0 and F2=0, then H2-D2 THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |