| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculation with a Blank or 0 Cell
=IFERROR(('Page 1'!I45+'Page 1'!F45)/2,"N/A")
Hi all, The above formula is what I need help with. I get the figure I want but the problem is that 'Page 1'!F45 might not have a percentage in it to calculate the total. So if I45 has 100% in it and F45 is 0%, or blank, then I get 50% for my total. I need it to say 100% if the second calculation is 0% or blank. The second calculation might not need to have anything in it to figure the numbers needed. If there is a calculation in F45 the formula works just fine. Thanks for any help, Planko |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I omit a blank cell from a calculation?? | Excel Worksheet Functions | |||
| Return Blank from Cell Calculation | Excel Worksheet Functions | |||
| How to leave a formula cell blank when it has no calculation to make | Excel Discussion (Misc queries) | |||
| Blank cell calculation | Excel Discussion (Misc queries) | |||
| Finding the first non-blank cell in a row and then applying a calculation | Excel Programming | |||
Threaded Mode
