| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you very much, that worked a treat!
"garfield-n-odie" wrote: =if($g1<0,if(($e1+$f1)/$g1=1,1,0),0) "Alicia" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
