| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No return for formula
Using formula - =if($f5"0",f5-e5,"") returns no response.
trying to get the difference b etwwen 2 dates where "F" column is day vehicle left and "E" column is day vehicle arrived. Is my formula wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
No return for formula
Try removing the quotation marks from around 0
=if($f50,f5-e5,"") "MPAVLAS" wrote: Using formula - =if($f5"0",f5-e5,"") returns no response. trying to get the difference b etwwen 2 dates where "F" column is day vehicle left and "E" column is day vehicle arrived. Is my formula wrong? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
No return for formula
Hi
I think you need =IF($F50,F5-E5,"") Format the cell as General. From your description, I'm not sure which is the later date. As long a column F is later than column E, then it will be fine. Otherwise you will need to reverse the calculation. -- Regards Roger Govier "MPAVLAS" wrote in message ... Using formula - =if($f5"0",f5-e5,"") returns no response. trying to get the difference b etwwen 2 dates where "F" column is day vehicle left and "E" column is day vehicle arrived. Is my formula wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Return Last Non-Zero Value in Row | Excel Worksheet Functions | |||
| I Need a Formula to return a zero value | Excel Worksheet Functions | |||
| Why does my formula return zero? | Excel Discussion (Misc queries) | |||
| Date formula...help with return on formula | Excel Worksheet Functions | |||
| I need help with way to return 0 or N/A to a formula | New Users to Excel | |||
Linear Mode
