Dear All

I have 3 columns D E F, where the user enters a number. ( Any number from 0
to 50)
Then in Column G, I have entered a formula to get a weighted average for
values entered in Col D or E or F

=IF(ISERROR((D52*3+E52*2+F52*1)/SUM(D52:F52)),"",(D52*3+E52*2+F52*1)/SUM(D52:F52))

Based on this Column H gets updated as either Fully Implemented \ Largely \
Partially
-----------------------------------------------------------------------------------------------
formula used is
=IF(G52=0,"Fully Imple.",IF(G52=1, "Largely Imple.", IF(G52=2, "Partially
Imple.", IF(G52=3,"Not Imple.", IF(G52="", "Fully Implemented")))))
-----------------------------------------------------------------------------------------------
My Problem
If I enter values in only 2 columns (D or E or F ) Column H shows false.

May I request your help once more.

Cordially - Beena K

How about

=IF(G52=0,"Fully Imple.",IF(G52<=1, "Largely Imple.", IF(G52<=2, "Partially
Imple.", IF(G52<=3,"Not Imple.", IF(G52="", "Fully Implemented")))))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Beena K" wrote in message
...
Dear All

I have 3 columns D E F, where the user enters a number. ( Any number from
0
to 50)
Then in Column G, I have entered a formula to get a weighted average for
values entered in Col D or E or F

=IF(ISERROR((D52*3+E52*2+F52*1)/SUM(D52:F52)),"",(D52*3+E52*2+F52*1)/SUM(D52:F52))

Based on this Column H gets updated as either Fully Implemented \ Largely
\
Partially
-----------------------------------------------------------------------------------------------
formula used is
=IF(G52=0,"Fully Imple.",IF(G52=1, "Largely Imple.", IF(G52=2, "Partially
Imple.", IF(G52=3,"Not Imple.", IF(G52="", "Fully Implemented")))))
-----------------------------------------------------------------------------------------------
My Problem
If I enter values in only 2 columns (D or E or F ) Column H shows false.

May I request your help once more.

Cordially - Beena K

Hi Bob

Thanks a million for the speedy response. The formula works.

Cordially
Beena K

"Bob Phillips" wrote:

How about

=IF(G52=0,"Fully Imple.",IF(G52<=1, "Largely Imple.", IF(G52<=2, "Partially
Imple.", IF(G52<=3,"Not Imple.", IF(G52="", "Fully Implemented")))))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Beena K" wrote in message
...
Dear All

I have 3 columns D E F, where the user enters a number. ( Any number from
0
to 50)
Then in Column G, I have entered a formula to get a weighted average for
values entered in Col D or E or F

=IF(ISERROR((D52*3+E52*2+F52*1)/SUM(D52:F52)),"",(D52*3+E52*2+F52*1)/SUM(D52:F52))

Based on this Column H gets updated as either Fully Implemented \ Largely
\
Partially
-----------------------------------------------------------------------------------------------
formula used is
=IF(G52=0,"Fully Imple.",IF(G52=1, "Largely Imple.", IF(G52=2, "Partially
Imple.", IF(G52=3,"Not Imple.", IF(G52="", "Fully Implemented")))))
-----------------------------------------------------------------------------------------------
My Problem
If I enter values in only 2 columns (D or E or F ) Column H shows false.

May I request your help once more.

Cordially - Beena K