![]() |
#1
|
|||
|
|||
![]()
I am working with the current formula but instead of having a FALSE value I would like the cell to be left blank until information is added to the spreadsheet.
=IF(AND(K2>115%,K2<1000%),"5",IF(AND(K2>105%,K2<11 5%),"4",IF(AND(K2>95%,K2<105%),"3",IF(AND(K2>85%,K 2<95%),"2",IF(AND(K2>0%,K2<85%),"1"))))) |
#2
|
|||
|
|||
![]()
How about try...
=IF(H2<>"",IF(AND(H2>115%,H2<1000%),"5",IF(AND(H2>105%,H2<115 %),"4",IF(AND(H2>95%,H2<105%),"3",IF(AND(H2>85%,H2 <95%),"2",IF(AND(H2>0%,H2<85%),"1"))))),"") but this seems to work better... =IF(H2<>"",LOOKUP(H2,{0,0.85,0.95,1.05,1.15},{1,2, 3,4,5}),"") |
#3
|
||||
|
||||
![]()
BTW is there any reason why the different results of the formula should be text ? "5" is a text string while 5 is a number
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rthomas | Excel | 6 | 10-24-2016 06:39 AM |
![]() |
zsteve | Excel | 4 | 08-11-2016 09:16 AM |
![]() |
Cosmo | PowerPoint | 14 | 11-03-2013 01:21 AM |
![]() |
peterv | Word | 5 | 07-19-2012 02:11 AM |
![]() |
Natasha | Excel | 1 | 09-25-2011 12:59 PM |