| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula not consistent
Hi. I'm stumped. I have a formula:
=ROUND(EmployeeData!AM6*(EmployeeData!$P6*'Emp Calendar'!F6-'Vacation Schedule'!I6)*ProgramOverview!$AR6,2) Sometimes I works fine and other times I have to go to the VacationSchedule sheet and enter a zero when there isn't a number in the cell in order to not have the #Value error show. Any ideas what it could be? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates not consistent | Excel Discussion (Misc queries) | |||
| Sub-Totals not consistent | Excel Discussion (Misc queries) | |||
| Dir command not consistent | Excel Programming | |||
| Keep consistent between two worksheets | Excel Discussion (Misc queries) | |||
| Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
Threaded Mode
