Hi All,
I have an excel forumla as follows:
=(B24/((B30*12)/100000))+(B26/((B32*12)/100000))
Sometimes the entires in either B24&B30 or B26&B32 will be zero and when that happens the forumla returns a result of #DIV/0!.
How can I make it so when either part is 0 it ignores that part and just works out the other part?
Many thanks
Last edited by langham; 06-01-2011 at 06:59 AM.
Hi,
Please read the forum rules and amend your thread title accordingly.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Apologies - amended now.
You should only need to test the divisor so maybe:
=IF(B30<>0,(B24/((B30*12)/100000)),0)+IF(B32<>0,(B26/((B32*12)/100000)),0)
Dom
Last edited by Domski; 06-01-2011 at 07:07 AM.
See if this does it for you:
=IF(B30=0,0,(B24/((B30*12)/100000)))+IF(B32=0,0,(B26/((B32*12)/100000)))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi Dom/TMShucks - worked perfect thank you so much for your help.
Cheers
You're welcome.
If this answers your question, please mark the thread as solved. See my signature for details or the FAQ.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks