formula adjustment

C

Candace

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

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top