StephanieH

Posts: n/a

Nested Funtions

Is it possible to add one more argument to this formula?

=IF(COUNT(OFFSET($B138,-4,0,-6,1))=6,AVERAGE(OFFSET(C138,-4,0,-6,1)),"N/A")

I want to specify that if the result of the average is an error, then also
return "N/A"

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 IF statements	John Simons	Excel Worksheet Functions	14	February 16th 05 06:17 AM
€œUse of more then 7 nested if statement€	Faisal Yameen	Excel Worksheet Functions	3	January 12th 05 06:02 PM
€œUse of more then 7 nested if statement€	Faisal Yameen	Excel Worksheet Functions	2	January 12th 05 04:20 PM
7+ nested if statement?	Turi	Excel Worksheet Functions	3	December 20th 04 07:55 PM
nested ifs	sthompson	Setting up and Configuration of Excel	1	December 15th 04 06:38 PM

All times are GMT +1. The time now is 05:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us