Formula to return blank
 

I have a formula =IF(H2D2+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

Formula to return blank
 

Maybe

=IF(H2=C2,"",IF(H2D2+E2,TODAY(),""))


--
Regards,

Peo Sjoblom


"Debsdad" wrote in message
...
I have a formula =IF(H2D2+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

Formula to return blank
 

I have a formula =IF(H2D2+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(H2D2+E2,TODAY(),""))

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

Rick

Formula to return blank
 

On Jul 3, 11:24 am, Debsdad wrote:
I have a formula =IF(H2D2+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

Formula to return blank
 

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?

"Peo Sjoblom" wrote:

Maybe

=IF(H2=C2,"",IF(H2D2+E2,TODAY(),""))


--
Regards,

Peo Sjoblom


"Debsdad" wrote in message
...
I have a formula =IF(H2D2+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

Formula to return blank
 

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

Formula to return blank
 

You guys are awesome, Thanks for the help!

Debsdad

"Rick Rothstein (MVP - VB)" wrote:

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

Formula to return blank
 

Try this:

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


"Debsdad" wrote:

I have a formula =IF(H2D2+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