View Single Post
  #4   Report Post  
jenniss
 
Posts: n/a
Default

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?