If 2 cells selected out of 3 - entry shows false

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beena K - 24 Apr 2008 07:54 GMT

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

Reply to this Message

Stefi - 26 Apr 2008 08:32 GMT

Your formula in H52 ALWAYS returns False if G52 doesn't equals an integer of
either 0 or 1 or 2 or 3 or empty string "".

Revise your method for handling fractional numbers in G52 and try to use in
H52 something like this formula:
=IF(G52>=0,"Fully",IF(G52>=1, "Largely", IF(G52>=2, "Partially",
IF(G52>=3,"Not", IF(G52="", "Fully","Not classified")))))

Regards,
Stefi

„Beena K” ezt írta:

> Dear All
>
[quoted text clipped - 18 lines]
>
> Cordially - Beena K

Reply to this Message