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 |
#2
|
|||
|
|||
Quote:
Hi Planko, You need IF statements in there to do this. It would be easier to show you how if you could post an example workbook. S. |
#3
|
|||
|
|||
Quote:
=IFERROR(IF(OR(F45=0,F45=""),I45,('Page 1'!I45+'Page 1'!F45)/2),"N/A") Does that do what you need? |
#4
|
|||
|
|||
Quote:
Not sure if this helps you. Planko |
#5
|
|||
|
|||
Quote:
Could you post an actual Excel file? It would make things easier to understand. If you don't wish to post it here, feel free to email it to the below email address. punut AT gmail DOT com (with no spaces and change the obvious for relevant symbols). |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation with a Blank or 0 Cell
Hi Planko,
Am Thu, 12 Jul 2012 16:13:32 +0000 schrieb Planko: =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. try: =IF('Page 1'!F45=0,'Page 1'!I45,AVERAGE('Page 1'!F45,'Page 1'!I45)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#7
|
|||
|
|||
Quote:
Thanks! That work perfectly. I really appreciate it. Let say I had three columns now with the same formula. Maybe one or two columns out of the three had inputted information. The others do not. I have tried myself and cannot figure it out. Planko |
Reply |
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 |