| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
