Hi I have tried make a formula for below criteria, and even i actually have got some help before similar( Not same)
I cant make it work. I am not that good to formulas.
This is the criteria.
All in sheet 1.
If cell O6 minus 50 type 0 in cell O8
If cell O6 is same or bigger than 50 type 25 in cell O8
If cell O6 is same or bigger than 80 type 50 in cell O8
If cell O6 is same or bigger than 90 type 75 in cell O8
If cell O6 is same or bigger than 100 type 100 in cell O8
I have made a table and tried with that. Its in cell x1 all can be seen in the below test sheet.
The table i have in the test sheet is named table2. In the real workbook i already have other table named table1
Try have a look at below test sheet.
Will be great if some can help with it.
Thanks in advance
Sincerely
Abjac
Bookmarks