| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
eliminating #value when computing average
An example:
if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a #value display in C1.. What is a good way to eliminate this? - or better yet to indicate A1 is blank, or B1 is blank? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
eliminating #value when computing average
=IF(ISERROR(A1/B1),"".A1/B1)
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Junior" wrote in message ... An example: if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a #value display in C1.. What is a good way to eliminate this? - or better yet to indicate A1 is blank, or B1 is blank? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
eliminating #value when computing average
Bob thanks
"Bob Phillips" wrote in message ... =IF(ISERROR(A1/B1),"".A1/B1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Junior" wrote in message ... An example: if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a #value display in C1.. What is a good way to eliminate this? - or better yet to indicate A1 is blank, or B1 is blank? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average & eliminating zero value Need HELP !! PLEASE | Excel Discussion (Misc queries) | |||
| Computing mortgage APR | Excel Worksheet Functions | |||
| COUNTIF not computing | Excel Discussion (Misc queries) | |||
| COMPUTING TWO COLUMNS | Excel Worksheet Functions | |||
| "Drop the lowest" in computing average | Excel Worksheet Functions | |||
![Junior[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
