Posted to microsoft.public.excel.worksheet.functions

T. Valko

external usenet poster

Posts: 15,768

Nested IF Statements

Try this...

=IF(A1="","",IF(COUNT(A1),IF(SQRT(A1)SQRT(AVERAGE (A$1:A$54)),1,IF(SQRT(A1)<SQRT(AVERAGE(A$1:A$54)),-1,"")),""))

--
Biff
Microsoft Excel MVP

wrote in message
...
Sorry, I did attempt to catch that with:

"Thanks. I used the formula as listed below. If I cell A1 is 0, A2 is
0
the cell B3 (I copy the formula down) lists as -1."

however I wasn't explicit enough with the expected outcome. In this
example B3 should be blank.

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	Valerie	Excel Worksheet Functions	2	February 19th 09 03:36 AM
nested IF statements	ssimer	Excel Worksheet Functions	3	August 22nd 08 12:47 AM
Nested if statements	JICDB	Excel Worksheet Functions	2	November 20th 07 06:48 PM
Nested If/Then statements	qwik6	Excel Worksheet Functions	3	December 9th 05 03:38 AM
I want to use more than 7 nested if then statements	IF I only had a brain for IF statements	Excel Worksheet Functions	11	August 9th 05 01:28 AM

All times are GMT +1. The time now is 04:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us