Posted to microsoft.public.excel.worksheet.functions

Kelly

external usenet poster

Posts: 132

Nested IF Functions

All three cells listed in the formula below are dates. If there is data in
cell R9, that cell should be calculated as below. If 01/00/00 is listed in
R9, the formula should calculate R4 in the same manner. I have started with
the following formula, but obviously have not incorporated in R4. Can anyone
help?

=IF($R$9-A73500,0,IF($R$9-A73<=0,0,IF($R$9-A730,SUM($R$9-A73))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Nested functions	Joyce	Excel Discussion (Misc queries)	4	January 18th 08 07:04 PM
too many nested IF functions	Amanda	Excel Worksheet Functions	5	October 6th 06 03:02 PM
Nested functions HELP!	chiefnmd	Excel Worksheet Functions	7	August 25th 05 05:20 AM
nested if(and) functions	Rohan	Excel Discussion (Misc queries)	3	August 12th 05 01:30 AM
Nested Functions	Steve Almond	Excel Worksheet Functions	2	June 14th 05 03:22 PM

All times are GMT +1. The time now is 01:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us