LinkBack URL
About LinkBacks
Hi Experts,
I need formula in status columns to update automatically according the criteria
from to Status
1% 10% Below
10.10% 30% Developing
30.10% 50% Stable
50.10% 85% Secure
85.10% 100% Mastering
I have attached screenshot.
Thanks in advance
Hi Experts,
I need formula in status columns to update automatically according the criteria
from to Status
1% 10% Below
10.10% 30% Developing
30.10% 50% Stable
50.10% 85% Secure
85.10% 100% Mastering
I have attached screenshot.
Thanks in advance
If I correctly allocate data and criteria:
Put into L2
Formula:
Please Login or Register to view this content.
and drag it down
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Hi farhangul,
You are looking for VLookup() with a TRUE argument.
Look at the Commission example on this page:
https://www.excelcampus.com/function...st-match-true/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks