| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to correct a #div/0! error but the IF function doesnt work
When i follow the conditional formatting instructions it doesnt remove the
#div/0! message that appears in the cells. Possibly this is because the worksheet has already been created so I am not entering this formula for each cell ... is there any quick way to do this to the whole worksheet? |
|
#2
|
|||
|
|||
|
Use an IF function
=IF(B1=0,"",A1/B1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Traceyb" wrote in message ... When i follow the conditional formatting instructions it doesnt remove the #div/0! message that appears in the cells. Possibly this is because the worksheet has already been created so I am not entering this formula for each cell ... is there any quick way to do this to the whole worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
| replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
| How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| How do I correct the #DIV/0! error? | Excel Worksheet Functions | |||
Linear Mode
