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

J

jenniss

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?
 
A

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"
 
J

jenniss

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

Aladin Akyurek said:
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?
Click to expand...
Click to expand...
 
J

jenniss

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?
 
J

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")
Click to expand...

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

Aladin left it out of his original formulas.

Cheers
JulieD

jenniss said:
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

Aladin Akyurek said:
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?
Click to expand...
Click to expand...
Click to expand...
 
R

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
 
Top