Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What IF - formula question
I have an 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
I have a question regarding countif formula. | Excel Worksheet Functions |