Bill R

Posts: n/a

Formula problem

=IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(F13) ),"",(SUM((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE))))*(360))*(F13 )))

The above formula calculates the "projected" year end sales gross. How do I
get the formula to automatically change the start date based on the actual
hire date of the employee if they are hired some time after the first of the
year?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with formula in Excel	Bill R	Excel Worksheet Functions	3	August 15th 05 03:02 AM
Formula problem on network	Philip Reece-Heal	Excel Discussion (Misc queries)	2	July 1st 05 01:15 PM
problem with Array Formula	OrdOff	Excel Worksheet Functions	2	June 30th 05 04:57 PM
Problem with formula	Sundaram Iyer	Excel Discussion (Misc queries)	0	June 1st 05 12:49 AM
Need a formula for this problem	Trying to excel in life but need help	Excel Worksheet Functions	1	January 12th 05 11:05 AM

All times are GMT +1. The time now is 02:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us