|
|
#1
01-31-2017, 05:06 PM
|
|||
|
|||
IF AND formula: replacing the FALSE Value with 0 when nothing entered
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
01-31-2017, 08:17 PM
|
|||
|
|||
|
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
02-01-2017, 12:42 AM
|
||||
|
||||
|
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
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Trying to create a formula for descriptions to be added if a code is entered
|
rthomas | Excel | 6 | 10-24-2016 06:39 AM |
|
Formula that will use different rates depending on the value entered
|
zsteve | Excel | 4 | 08-11-2016 09:16 AM |
|
Embedded SWF - 'Playing' is false after run
|
Cosmo | PowerPoint | 14 | 11-03-2013 01:21 AM |
|
False fonts in word
|
peterv | Word | 5 | 07-19-2012 02:11 AM |
|
Formula to select description when code is entered
|
Natasha | Excel | 1 | 09-25-2011 12:59 PM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
