Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using the =networkingdays(a1,b1,holidays) to business days for the
month. I want to multiply the Month To Date sales in dollars by the results of the above formula to generate the projected sales in dollars ($) for the month. When I try it now it give me an un-godly number in the millions when I know that the results should be in the $150,000.00 range. Where did I go wrong? What did I leave out? Set me straight & earn the thanks of a grateful old actor. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) |