Formula to return blank

[Guest]

I have a formula =IF(H2>D2+E2,TODAY()), but I need to have it come back as a
blank if H2 is = to C2. Could someone please help with this?

Thanks
Debsdad

 

[Peo Sjoblom]

Maybe

=IF(H2=C2,"",IF(H2>D2+E2,TODAY(),""))

 

[Rick Rothstein \(MVP - VB\)]

I have a formula =IF(H2>D2+E2,TODAY()), but I need to have it come back as

a
blank if H2 is = to C2. Could someone please help with this?

Maybe this...

=IF(H2=C2,"",IF(H2>D2+E2,TODAY(),""))

Note: I added a blank return value for your original formula if the logical
condition fails.

Rick

 

[vincentwady]

I have a formula =IF(H2>D2+E2,TODAY()), but I need to have it come back as a
blank if H2 is = to C2. Could someone please help with this?

Thanks
Debsdad

=IF(H1=C1,"",IF(H1>(D1+E1),TODAY()))

I think this could work for you. Try it, and let me know whether you
need more help.

Vincent

 

[Guest]

Thanks, it worked great! Now that it returned a date I need to have the next
coloumn add days based on anoter cell so it would be like this: IF F2=date
then add formula from cell J2. Can this be done?

 

[Rick Rothstein \(MVP - VB\)]

Thanks, it worked great! Now that it returned a date I need to have the

next
coloumn add days based on anoter cell so it would be like this: IF F2=date
then add formula from cell J2. Can this be done?

What is in J2... a number of days? Maybe you want something like this...

=IF(F2<>"",F2+J2,"")

where I only test for <>"" because I assume the formula Peo and I posted is
what is in F2.

Rick

 

[Guest]

You guys are awesome, Thanks for the help!

Debsdad

 

[Guest]

Try this:

=IF(OR(H2=C2,H2<D2+E2),"",TODAY())