If 2 cells selected out of 3 - entry shows false

  • Thread starter Thread starter Beena K
  • Start date Start date
B

Beena K

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
 
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:
 
Back
Top