formula adjustment

[Guest]

I am using the following formula with works great, but I need to add
something to it.

=IF(AND(TODAY()>=C35,TODAY()<=D35,ISBLANK(G2)),C2+I2,"")

In addition to the criteria in this formula I need to add logic that says:

If G2 is "not" blank, give the sum of C2 - H2 + I2

My problem is I don't know how to include all of this logic in a single
formula. Any ideas?

 

[Ian]

I might be wrong but it seems to me that if G" is not blank, then the IF
condition is not met, so replacing "" with C2-H2+I2 should do the trick.

Ian

 

[Rick Rothstein \(MVP - VB\)]

I think this formula does what you want...

=IF(AND(TODAY()>=C35,TODAY()<=D35),IF(ISBLANK(G2),C2+I2,C2 - H2 + I2),"")

Rick