Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement with 3 possible outcomes
HELP!!!
Cell H5 is either blank (empty), contains "N/A", or has a date. Cell I5 will either be blank if H5 is blank, show "N/A" if H5="N/A", or take the date in H5 and add 45 days to it. Could someone please give me the formula that should be in I5? I've tried =IF(H5=" "," "),IF(H5="N/A","N/A",SUM(H5+45)) but got #VALUE! regardless of the contents of H5. Thanks for the help! |
#2
|
|||
|
|||
Hi
try =IF(H5="","",IF(H5="N/A",H5,H5+45)) -- Regards Frank Kabel Frankfurt, Germany "djmillis" schrieb im Newsbeitrag ... HELP!!! Cell H5 is either blank (empty), contains "N/A", or has a date. Cell I5 will either be blank if H5 is blank, show "N/A" if H5="N/A", or take the date in H5 and add 45 days to it. Could someone please give me the formula that should be in I5? I've tried =IF(H5=" "," "),IF(H5="N/A","N/A",SUM(H5+45)) but got #VALUE! regardless of the contents of H5. Thanks for the help! |
#3
|
|||
|
|||
Thanks Frank - You're the Best!
I guess I was on the right track. Just had too much syntax there. "Frank Kabel" wrote: Hi try =IF(H5="","",IF(H5="N/A",H5,H5+45)) -- Regards Frank Kabel Frankfurt, Germany "djmillis" schrieb im Newsbeitrag ... HELP!!! Cell H5 is either blank (empty), contains "N/A", or has a date. Cell I5 will either be blank if H5 is blank, show "N/A" if H5="N/A", or take the date in H5 and add 45 days to it. Could someone please give me the formula that should be in I5? I've tried =IF(H5=" "," "),IF(H5="N/A","N/A",SUM(H5+45)) but got #VALUE! regardless of the contents of H5. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
IF Statement difficulty | Excel Worksheet Functions |