|
DIV/0
I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such
as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
You can use "IsError" to get what you want.
=If(IsError(B1/C1),"NO CALC. POSSIBLE",B1/C1) Charles Chickering F. Lawrence Kulchar wrote: I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc)
NickHK "F. Lawrence Kulchar" wrote in message ... I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
THANK YOU
"Die_Another_Day" wrote: You can use "IsError" to get what you want. =If(IsError(B1/C1),"NO CALC. POSSIBLE",B1/C1) Charles Chickering F. Lawrence Kulchar wrote: I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
Thank you
"NickHK" wrote: You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc) NickHK "F. Lawrence Kulchar" wrote in message ... I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
NickHK, this would create a circular reference since the formula needs to go
into cell A3. Also: IsError catches ANY error, not just Div/0. Why not simply IF(A1=0,"No Calc Possible",5/A1+A2)? Cheers Joerg "NickHK" wrote in message ... You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc) NickHK "F. Lawrence Kulchar" wrote in message ... I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
DIV/0
I didn't examine the OP's structure/data, just pointed out the existence of
ISERROR. If the OP wishes to check the Help and/or other references that would be a good thing. As you say, there are other (better) ways of achieving the goal. NickHK "Joerg" wrote in message ... NickHK, this would create a circular reference since the formula needs to go into cell A3. Also: IsError catches ANY error, not just Div/0. Why not simply IF(A1=0,"No Calc Possible",5/A1+A2)? Cheers Joerg "NickHK" wrote in message ... You can use =IF(ISERROR(A3),"No Calc Possible",<Some Calc) NickHK "F. Lawrence Kulchar" wrote in message ... I have a spreadsheet wherein i receive a CORRECT error message "DIV/0" such as as follows: A B C D E 1 10 5 0 0 10 2 3.00 =A3 =B3 =C3 =D3 3 =5/A1 + =5/B1 + =5/C1 + =5/D1 + =5/E1+ A2 B2 C2 D2 E2 3 3.50 4.50 DIV/0 DIV/0 5.00 I am keeping, eg, a rolling (running) average. QUESTION: IS IT POSSIBLE, for my spreadsheet purpose only, TO ... INSTEAD OF DISPLAYING "DIV/0", I can display, for example, a text message such as..."NO CALC. POSSIBLE" ?? In other words, can I use the IF function to say... =If(a3="DIV/0", "No Calc. Possible, a3) Thanks, FLKulchar |
| All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com