#DIV/0 Error
How would I write this function:
If A2/A1=0 or #DIV/0 Error, then enter 0.00%, otherwise enter finish calculation. For Example A2=2 and A1=1, in cell B2 50.00% would show up. But if A2=0 and A1=0 (only because data hasnt been entered there yet), then just enter 0.00% thanx |
Hi
=IF(A1=0,0,A2/A1) Arvi Laanemets "Dominique Feteau" wrote in message ... How would I write this function: If A2/A1=0 or #DIV/0 Error, then enter 0.00%, otherwise enter finish calculation. For Example A2=2 and A1=1, in cell B2 50.00% would show up. But if A2=0 and A1=0 (only because data hasnt been entered there yet), then just enter 0.00% thanx |
oh gheez. i need to stop drinking and trying to think of functions at the
same time... niq "Arvi Laanemets" wrote in message ... Hi =IF(A1=0,0,A2/A1) Arvi Laanemets "Dominique Feteau" wrote in message ... How would I write this function: If A2/A1=0 or #DIV/0 Error, then enter 0.00%, otherwise enter finish calculation. For Example A2=2 and A1=1, in cell B2 50.00% would show up. But if A2=0 and A1=0 (only because data hasnt been entered there yet), then just enter 0.00% thanx |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com