Looking for help with a formula that will read from cells in column B starting with B2
Formula needs to contain the following parameters
If >.93=”On Target”
If >.89 <.93=”In 90’s”
If >.79 <.90=”In 80’s”
If <.80=”Below 80%”
Looking for help with a formula that will read from cells in column B starting with B2
Formula needs to contain the following parameters
If >.93=”On Target”
If >.89 <.93=”In 90’s”
If >.79 <.90=”In 80’s”
If <.80=”Below 80%”
Try:
=lookup(b2,{0,0.8,0.9,0.93},{"Below 80%","In 80s","In 90s","On Target"})
Last edited by Glenn Kennedy; 06-19-2024 at 11:36 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Try
Formula:
=IF(A2>0.93,"On target",IF(A2>=0.9,"In 90s",IF(A2>=0.8,"In 80s","Below 80%")))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks