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

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

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