Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I tried the suggestions that were given to me. The only problem is that they will show a percentage in .00 instead of %. They want me to get the the answer in %. I just cannot get this to work. It will work once the cells are filled and it computes. But until then the cell shows #DIV/0! Original Message: Hi, How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my cells that use this formula. thanks for anyhelp that you can give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Part Formula | Excel Worksheet Functions | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Help on any part of this would be great | Excel Discussion (Misc queries) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
Excel Web Part | Excel Discussion (Misc queries) |