Calculation within a calculation

[Mike]

I'm trying to take cell A1 and subtract it from cell B1
and if the two cells equal then input text in cell
C1 "Balanced", if the two cells do not equal then input
text in cell C1 "Out of balance by (what the actual
difference is)". Does anyone know the formula to use?
Thanks

 

[Alan]

If I understand you correctly try
=IF(A1-B1=0,"Balanced","Out of balance by "&A1-B1)
Regards,

 

[Guest]

=IF((A1-B1=0),"Balanced","Out of balance by "&(B1-A1))

 

[Gabor Sebo]

-----Original Message-----
I'm trying to take cell A1 and subtract it from cell B1
and if the two cells equal then input text in cell
C1 "Balanced", if the two cells do not equal then input
text in cell C1 "Out of balance by (what the actual
difference is)". Does anyone know the formula to use?
Thanks
.

Hello,

Insert into C1:
=if(exact(a1,b1),"balanced","unbalanced")