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
01:16 AM
.
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com