I have seen people in this forum helping each other in solving their issues which is very good for people like us who are stuck in finding solutions. I also have request on IF formula. I am designing a price table based on USD VALUE.
I want the results to appear in column "C" based on the application which is shown from A12:A19. Example:-
1) If the USD VALUE IS LESS THAN OR EQUAL TO 5, THEN WE NEED TO APPLY 150% (5*150%)
2) If the USD VALUE IS BETWEEN 6-10, THEN WE NEED TO APPLY 120%
I tried formulating but didn't work. My results are appearing in Column E2:E9
Please help me.
Bookmarks