Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing errors
Hi all I have a s/sheet in the middle of being set up. I need to create a formula based on columns E, G & I. I need Column K to average the percentage of those previous 3 columns. Column I will be presented in a number format (1-5) these are converted to percentages (see field K18 for an example of what each number is converted to) The problem I'm facing is this.........I want the formula to be pretty robust so that if for any reason, columns E, G or I (or any combination of the 3) are not completed, the average percentage in column K is still calculated. For example, if I populate column E18 with 100%, G18 leave blank and I18 insert a 3, column K appears as 100%. This is clearly incorrect as the average of 100% and 50% (where 3 = 50%) should be 75% !!! Any help please ? +-------------------------------------------------------------------+ |Filename: 1107Surveys(store)2.zip | |Download: http://www.excelforum.com/attachment.php?postid=4353 | +-------------------------------------------------------------------+ -- koit ------------------------------------------------------------------------ koit's Profile: http://www.excelforum.com/member.php...o&userid=31100 View this thread: http://www.excelforum.com/showthread...hreadid=511998 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Form File Errors | Excel Discussion (Misc queries) | |||
Shared sheet errors | Excel Discussion (Misc queries) | |||
Subtotal excl errors | Excel Worksheet Functions | |||
Errors accessing shared speadsheet. | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |