| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#div/0! problem - please help
I have a formula as follows:
=IF(($E1+$F1)/$G1=1,1,0) However, if the value in G1 = 0 , then my formula shows #div/0! How do I solve this? Alicia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
| Problem with date base units for x axis | Charts and Charting in Excel | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Threaded Mode
