Help with "IF" Formula

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

Yogi,

It works fine for me, although it can be reduced to

=IF(G112>0,G112,IF(F112>0,F112,E112))+365

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=IF((G112>0),(G112+365),IF((F112>0),(F112+365),(E112+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
 
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
 
Back
Top