formula for percentage

  • Thread starter Thread starter jv
  • Start date Start date
J

jv

Good evening to all,

Can you please help me make a formula for my percentage
column.
A B C D E
Budget Wkly Exp. P.Order Balance %Used
33,000 17,500 5,000 10,500
0 3,500 -3,500 #DIV/0!

The formula sum(B2:C2)/A2 works well but in the case of
column E3 i get an error result. Is there a formula to
avoid this because later on budget will be added on column
A.

Thanks in advance.

jv
 
jv,

Check your divisor first for a zero before computing the percentage.

=IF(A2=0,'',Sum(B2:C2)/A2 )

John
 
JV, You can add an IF statement to your percentage
formula. By looking at the A Column first before it does
the calc.
In E2:
=IF(A2="",0%,SUM(B2:C2)/A2)
Autofill down.
HTH
Kevin M
 
I've been using excel more than a year now but im not that
good in composing complicated formulas, from reading thru
various threads and with your advises im beginning to
appreciate the beauty and the power of excel.

Surely, theres a lot more things to learn from you guys.

To you John, Kevin & Frank, thank you so much!

Regards,

jv
 
Back
Top