ExcelBanter - =(F23+F25+F27+F29)/F33 gives me an error #DIV/0! How do I get ri.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =(F23+F25+F27+F29)/F33 gives me an error #DIV/0! How do I get ri. (https://www.excelbanter.com/excel-discussion-misc-queries/21695-%3D-f23-f25-f27-f29-f33-gives-me-error-div-0-how-do-i-get-ri.html)

jetpilot1

=(F23+F25+F27+F29)/F33 gives me an error #DIV/0! How do I get ri.

Help please.

CLR

Try this.........

=IF(F33<0,(F23+F25+F27+F29)/F33,"")

Vaya con Dios,
Chuck, CABGx3

"jetpilot1" wrote in message
...
Help please.

J Smith

Generally a #DIV/0 means the divisor is a zero. So what is in cell f33?
Remember that numbers entered at text are treated as zeros.

"jetpilot1" wrote in message
...
Help please.

All times are GMT +1. The time now is 06:00 PM.