Contingency

[Doug Holtz]

I want to fill in a percentage in a field marked Contingency ____% and have
that calculate out fields to the right. This is what I have so far:
=IF(OR(SUM(C2828)=0,SUM(C2727)=0),"Contingency ____
%",TEXT(SUM(C2828)/SUM(C2727),"0%")&"
This is field B28. There are subtotals in C27 and D27. Totals for the
sheet are in C29 and D29.
What should happen in fields C28, D28, C27, and D27?
Currently when I put in a % in the contingency, nothing happens. If I put
in a number in the C28 field I get a % calculation in the B28 contingency
field.
tnx
doug

 

[Bernie Deitrick]

Doug,

Try:

=IF(AND(SUM(C2828)<>0,SUM(C2727)<>0),"Contingency is " &TEXT(SUM(C2828)/SUM(C2727),"0%"),"")

HTH,
Bernie
MS Excel MVP

 

[Doug Holtz]

Bernie;

Thank you for the reply. I tried your formula revision and it calculates.
I'll give it to the user and see if it solves the problem I had.

Doug