Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to not get '0' or '#DIV/0!' in a cell with a percentage formul
I am trying to get rid of the "zeros" and "#DIV/0!" in a cell with a cell a
percentage formula. Example: Column A2 = Numerator Column B2 = Denominator Then for % formula I do the following in column A1: =A2/B2 And this gives me a the cell A1 with percent formula but if the cells A2 and B2 are blank then it gives "#DIV/0!". Can we design this formula in such a way that the target cell (A1) remains empty but still has the formula? Also, how can I lock the formula cells so that no one can change it? Please help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you modify the background color of a cell by using formul. | Excel Worksheet Functions | |||
adding a formul to the next cell only with the next cell number | Excel Discussion (Misc queries) | |||
Can you change the relative reference of a cell in an Excel formul | Excel Discussion (Misc queries) | |||
Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions | |||
can you use a variable or cell reference in a getpivotdata formul. | Excel Worksheet Functions |