Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! - how to get rid of it
I have a user that the formula is H3=G3/F3 - where both g3 and f3 are blank
b/c they are not populated. The user wants them there so when the field would be populated they would fill H3 correctly. The customer doesnt want to see #DIV/0! going down the page. How could i fix this issue without having 0 all the way down and still have the functionality when the fields are populated? |