|
Entering only 2 values out of 3 - throws up message as false
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 |
Entering only 2 values out of 3 - throws up message as false
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 |
Entering only 2 values out of 3 - throws up message as false
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 |
| All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com