have cell display the word balance when a equals the same amount a

[Guest]

I want a cell to display the word balance

example cell "A" is the same amount in cell "B" cell "C" will say BALANCE

is this possible?

 

[Aladin Akyurek]

One of:

1]

=IF(ROUND(A2,2)=ROUND(B2),"BALANCE","AUDIT")

2]

=ROUND(A2,2)-ROUND(B2)

Custom format C2, the formula cell (of [2]) as:

[=0]"BALANCE";[<>0]"AUDIT"

 

[R D S]

Put into cell C1
=IF(A1=B1,"BAL","")

 

[Guest]

OK, i assume where instead of puttin (a2,2) i put the cell i want (h36) and
instead of putting (b2) i put b41 the problem is now where i am putting the
formula in cell g36 it coming up with the following error "you have entered
few to arguments"

any ideas?

i confirm in cell G36 i have put the formula
=IF(ROUND(h36,2)=ROUND(B41),"BALANCE","AUDIT")

(i have copied and pasted the formula from your reply and adjucted it to the
cells i want

One of:

1]

=IF(ROUND(A2,2)=ROUND(B2),"BALANCE","AUDIT")

2]

=ROUND(A2,2)-ROUND(B2)

Custom format C2, the formula cell (of [2]) as:

[=0]"BALANCE";[<>0]"AUDIT"

I want a cell to display the word balance

example cell "A" is the same amount in cell "B" cell "C" will say BALANCE

is this possible?

 

[Guest]

THANKYOU that has worked

Put into cell C1
=IF(A1=B1,"BAL","")

 

[Guest]

ok another question if the vaules are not the same can it display the word
not balance and if it is the same it will display balance?

 

[L. Howard Kittle]

Hi Jenniss,

=IF(A1=B1,"Balance","Not Balance")

HTH
Regards,
Howard

 

[JulieD]

Hi

i know you've got the other formula working - but i thought i might just
comment on the error you were experiencing with this one -

=IF(ROUND(h36,2)=ROUND(B41),"BALANCE","AUDIT")

should be
=IF(ROUND(h36,2)=ROUND(B41,2),"BALANCE","AUDIT")

Aladin left it out of his original formulas.

Cheers
JulieD

OK, i assume where instead of puttin (a2,2) i put the cell i want (h36)
and
instead of putting (b2) i put b41 the problem is now where i am putting
the
formula in cell g36 it coming up with the following error "you have
entered
few to arguments"

any ideas?

i confirm in cell G36 i have put the formula
=IF(ROUND(h36,2)=ROUND(B41),"BALANCE","AUDIT")

(i have copied and pasted the formula from your reply and adjucted it to
the
cells i want

One of:

1]

=IF(ROUND(A2,2)=ROUND(B2),"BALANCE","AUDIT")

2]

=ROUND(A2,2)-ROUND(B2)

Custom format C2, the formula cell (of [2]) as:

[=0]"BALANCE";[<>0]"AUDIT"

I want a cell to display the word balance

example cell "A" is the same amount in cell "B" cell "C" will say
BALANCE

is this possible?

 

[R D S]

Put the other word between the second quotes ie

=IF(A1=B1,"BAL","NOT BAL")

Glad to be of help, I usually just post questions!
Rick