Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 05, 02:05 PM
jenniss
 
Posts: n/a
Default have cell display the word balance when a equals the same amount a

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?

  #2   Report Post  
Old February 6th 05, 02:21 PM
Aladin Akyurek
 
Posts: n/a
Default

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?

  #3   Report Post  
Old February 6th 05, 02:47 PM
R D S
 
Posts: n/a
Default

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

"jenniss" wrote in message
...
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?



  #4   Report Post  
Old February 6th 05, 03:27 PM
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?


  #5   Report Post  
Old February 6th 05, 03:29 PM
jenniss
 
Posts: n/a
Default

THANKYOU that has worked

"R D S" wrote:

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

"jenniss" wrote in message
...
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?






  #6   Report Post  
Old February 6th 05, 03:33 PM
jenniss
 
Posts: n/a
Default

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?

"jenniss" wrote:

THANKYOU that has worked

"R D S" wrote:

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

"jenniss" wrote in message
...
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?




  #7   Report Post  
Old February 6th 05, 04:22 PM
L. Howard Kittle
 
Posts: n/a
Default

Hi Jenniss,

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

HTH
Regards,
Howard

"jenniss" wrote in message
...
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?



  #8   Report Post  
Old February 6th 05, 04:24 PM
JulieD
 
Posts: n/a
Default

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

"jenniss" wrote in message
...
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?




  #9   Report Post  
Old February 6th 05, 05:06 PM
R D S
 
Posts: n/a
Default

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

"jenniss" wrote in message
...
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?

"jenniss" wrote:

THANKYOU that has worked

"R D S" wrote:

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

"jenniss" wrote in message
...
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?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 04:43 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 05:09 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
how to display heading of column corresponding to the cell angelrain Excel Worksheet Functions 2 November 2nd 04 04:57 PM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017