Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
how to display heading of column corresponding to the cell | Excel Worksheet Functions |