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%"

Equity	15%
Bond	3%

<tbody>
</tbody><colgroup><col><col></colgroup>

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

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[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

Secuity	Tollarance	action required
Equity	9%	No
Bond	6%	Yes
Equity	11%	yes
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...	4%	No

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[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

	A	B	C	D	E
1	Code	Which formula should we Use	Example need	which formula ?	Example need
2	450216785	(Need Secount last character or number only )	8	if C2 = Number then "Equity" if its alphabet it should be "Bond"	Equity
3	5502167B5		B		Bond
4	6702167C2		C		Bond
5	890216785		8		Equity
6	4502167G1		G		Bond

<tbody>
</tbody>

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