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" wrote:
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"
jenniss wrote:
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?
|