| Home > Forum Home > Presenting and Reporting Data > IF statement to rid the sheet of "#Div/0" > rid of div/0 | Share |
Rid of div/0
Excel Help for Rid Of Div/0 in Presenting and Reporting Data
| Forum Topic | Login |
Rid Of Div/0 | Rate this: (3/5 from 1 vote) |
 | the formula will be try this formula =if(iserror(SUM('Active Job Hours '!G4/'Active Job Hours '!E4)*1),"",SUM('Active Job Hours '!G4/'Active Job Hours '!E4)*1) | |
| Posted by [email protected] on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for rid of div/0 in the Excel Business Solutions Directory |