| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why isn't this formula calculating correctly?
Dave F wrote:
Here's the formula: =IF(I$6<$G14,"",IF($F14<0,"N/A",IF(DATEDIF($G14,I$6,"m")/$B$3*$F14$F14,"",DATEDIF($G14,I$6,"m")/$B$3*$F14))) I6 is 4/30/2006, G14 is 3/31/2006, F14 is $85,968, B3 is 48 I think it should resolve to 1/48*$85,968 = $1,791. But excel is calculating it as $0.00. Thoughts? DATEDIF() is returns zero for those two dates. Apparently DATEDIF() does not consider them to be a month apart. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
