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