| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| If cell blank return a blank | Excel Worksheet Functions | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
| Formula ? Return value from rightmost non-blank cell in a row of | Excel Worksheet Functions | |||
| Return blank cell using a formula | New Users to Excel | |||
Hybrid Mode
