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?

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

"Candace" wrote in message
...
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?

I think this formula does what you want...

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

Rick


"Candace" wrote in message
...
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?