Click here to Skip to main content
14,766,280 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
need a formaulae for below conditions,

cell no RATING
A2 2
A3 5
A4 7
A5 6
A6 1
A7 8
A8 3
A9 4
A10 9

CONDITIONS IS LIKE IF RATING IS 2 OR 4 THEN 10%, 3 OR 7 OR 6 THEN 5%, 8 OR 9 THEN 0%,5 THEN 8% , 1 THEN 15%.

PLEASE HELP WITH ONE FORMULAE.
Posted

1 solution

Learn From Here:

MS Excel: If Function[^]
   
Comments
YuDi Sri 15-Feb-12 1:16am
   
thanks for ur valuable feedback.

thats what i tried n got the result.

=IF(OR(J2=2,J2=4),10%,IF(OR(J2=3,J2=7,J2=6),5%,IF(OR(J2=8,J2=9),0%,IF(J2=5,8%,IF(J2=1,15%,"N/A")))))

this is for your future purpose, no need to go to http://www.techonthenet.com/excel/formulas/if.php
:P

once again thanks a lot

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900