Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "IF" Formula
Yogi,
It works fine for me, although it can be reduced to =IF(G1120,G112,IF(F1120,F112,E112))+365 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Yogi_Bear_79" wrote in message ... =IF((G1120),(G112+365),IF((F1120),(F112+365),(E1 12+365))) Can't seem to get this right. It works if there is data in Cell G112 or F112. But returns a #Value error if both G112 & F112 are NULL Ideally what should happen is this. The due column "H" should show thenext due date. The due date is calculated by adding 365 days to the last completed date. The last completed date could be in column E~G. I want to start by looking at "G" if ISNULL then check "F" is ISNULL then use data from "E". Esle add 365 days to the first column it findsdata in |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "IF" Formula
=IF((G1120),(G112+365),IF((F1120),(F112+365),(E1 12+365)))
Can't seem to get this right. It works if there is data in Cell G112 or F112. But returns a #Value error if both G112 & F112 are NULL Ideally what should happen is this. The due column "H" should show thenext due date. The due date is calculated by adding 365 days to the last completed date. The last completed date could be in column E~G. I want to start by looking at "G" if ISNULL then check "F" is ISNULL then use data from "E". Esle add 365 days to the first column it findsdata in |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "IF" Formula
Thanks for shortening it!
You right it does work, after I placed cursor in cell and hit delete, apparently there was still something in there "Bob Phillips" wrote in message ... Yogi, It works fine for me, although it can be reduced to =IF(G1120,G112,IF(F1120,F112,E112))+365 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Yogi_Bear_79" wrote in message ... =IF((G1120),(G112+365),IF((F1120),(F112+365),(E1 12+365))) Can't seem to get this right. It works if there is data in Cell G112 or F112. But returns a #Value error if both G112 & F112 are NULL Ideally what should happen is this. The due column "H" should show thenext due date. The due date is calculated by adding 365 days to the last completed date. The last completed date could be in column E~G. I want to start by looking at "G" if ISNULL then check "F" is ISNULL then use data from "E". Esle add 365 days to the first column it findsdata in |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |