Excel Formula

[anand6802]

hi all

i have one question related to excel formula

example

in A1 cell "Equity" and A2 cell "Bond same in B1 "15%" and B2 "3%"

[TABLE="width: 187"]
<tbody>[TR]
[TD]Equity[/TD]
[TD="align: right"]15%[/TD]
[/TR]
[TR]
[TD]Bond[/TD]
[TD="align: right"]3%[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]
[TABLE="width: 187"]
<tbody>[TR]
[TD]i just want the formula that if euity is below 10% or bond below 5% then it should be fine other wise not fine in cloum C

[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[anand6802]

please guys advice on below issues

 

[FormR]

please guys advice on below issues

Hi, you should be a little more patient when waiting for a response

You could try:

=IF(OR(B1<10%,B2<5%),"Fine","Not Fine")

 

[anand6802]

Hi FormR

[TABLE="width: 296"]
<tbody>[TR]
[TD]Secuity[/TD]
[TD]Tollarance[/TD]
[TD]action required[/TD]
[/TR]
[TR]
[TD]Equity[/TD]
[TD]9%[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]Bond[/TD]
[TD]6%[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Equity[/TD]
[TD]11%[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]Bond

i used if(or) foumula but its doesn't work when its chaged from equity to bond...

for Equity tolerance is less than 10% then its file no need to take any action....

and for bond the tolerance limit is less than 5% then its no need to take action...

[/TD]
[TD]4%
[/TD]
[TD]No

[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[FormR]

Hi, something like this maybe?

Excel 2012
	A	B	C
1	Secuity	Tollarance	action required
2	Equity	9%	No
3	Bond	6%	Yes
4	Equity	11%	Yes
5	Bond	4%	No
Sheet1

Cell Formulas
Range	Formula
C2	=IF(OR(AND(A2="Equity",B2<10%),AND(A2="Bond",B2<5%)),"No","Yes")

 

[anand6802]

Hi FormR

Thanks a lot ......

Its working ....

I have one more question
[TABLE="width: 1115"]
<tbody>[TR]
[TD]



[/TD]
[TD]
A


[/TD]
[TD]
B


[/TD]
[TD]
C


[/TD]
[TD]
D


[/TD]
[TD]
E


[/TD]
[/TR]
[TR]
[TD]

1


[/TD]
[TD]
Code


[/TD]
[TD]
Which formula should we Use


[/TD]
[TD]
Example need


[/TD]
[TD]
which formula ?


[/TD]
[TD]
Example need


[/TD]
[/TR]
[TR]
[TD]

2


[/TD]
[TD]
450216785


[/TD]
[TD]
(Need Secount last character or number only
)


[/TD]
[TD]
8


[/TD]
[TD]
if C2 = Number then "Equity" if its alphabet it should be
"Bond"


[/TD]
[TD]
Equity


[/TD]
[/TR]
[TR]
[TD]

3


[/TD]
[TD]
5502167B5


[/TD]
[TD]


[/TD]
[TD]
B


[/TD]
[TD]


[/TD]
[TD]
Bond


[/TD]
[/TR]
[TR]
[TD]

4


[/TD]
[TD]
6702167C2


[/TD]
[TD]


[/TD]
[TD]
C


[/TD]
[TD]


[/TD]
[TD]
Bond


[/TD]
[/TR]
[TR]
[TD]

5


[/TD]
[TD]
890216785


[/TD]
[TD]


[/TD]
[TD]
8


[/TD]
[TD]


[/TD]
[TD]
Equity


[/TD]
[/TR]
[TR]
[TD]

6


[/TD]
[TD]
4502167G1


[/TD]
[TD]


[/TD]
[TD]
G


[/TD]
[TD]


[/TD]
[TD]
Bond
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance...

 

[FormR]

Something like this may work:

Excel 2012
	A	B	C
2	450216785	8	Equity
3	5502167B5	B	Bond
4	6702167C2	C	Bond
5	890216785	8	Equity
6	4502167G1	G	Bond
Sheet1

Cell Formulas
Range	Formula
B2	=MID(A2,LEN(A2)-1,1)
C2	=IF(ISNUMBER(B2+0),"Equity","Bond")

 

[anand6802]

amazing..............great

 

[FormR]

Glad it helped, oh and welcome to MrExcel