Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what IF - formula question
=IF(G43=0,"",sum(hH43/G32)).
This will avoid division by zero so #DIV/0 will not appear. Also if you want to drag the formula, I think you should use fixed reference ($G$32) instead of relative reference (G43). "Gene" wrote in message ... Sorry for the multiple posts. Twice a window opened when I clicked post and said there was an error and it did not post. again sorry. -- Gene "Gene" wrote: What IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I cant figure out how to do this. Thanks for your time and help! -- Gene |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what IF - formula question
What IF formula question. My cell has a formula in it =sum(H43/G43). I
want this cell blank If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I cant figure out how to do this. Thanks for your time and help! -- Gene |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what IF - formula question
Sorry for the multiple posts. Twice a window opened when I clicked post and
said there was an error and it did not post. again sorry. -- Gene "Gene" wrote: What IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I cant figure out how to do this. Thanks for your time and help! -- Gene |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what IF - formula question
But the SUM function is not needed
=IF(G43=0,"",H43/G32). -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Rasoul Khoshravan" wrote in message ... =IF(G43=0,"",sum(hH43/G32)). This will avoid division by zero so #DIV/0 will not appear. Also if you want to drag the formula, I think you should use fixed reference ($G$32) instead of relative reference (G43). "Gene" wrote in message ... Sorry for the multiple posts. Twice a window opened when I clicked post and said there was an error and it did not post. again sorry. -- Gene "Gene" wrote: What IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what IF - formula question
except I need the G43=0 to include + & - results. I only need #div/0! to be
shown as nothing. -- Gene "Bernard Liengme" wrote: But the SUM function is not needed =IF(G43=0,"",H43/G32). -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Rasoul Khoshravan" wrote in message ... =IF(G43=0,"",sum(hH43/G32)). This will avoid division by zero so #DIV/0 will not appear. Also if you want to drag the formula, I think you should use fixed reference ($G$32) instead of relative reference (G43). "Gene" wrote in message ... Sorry for the multiple posts. Twice a window opened when I clicked post and said there was an error and it did not post. again sorry. -- Gene "Gene" wrote: What IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula question | Excel Worksheet Functions | |||
Repeating Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions |