Thread: IF AND formula: replacing the FALSE Value with 0 when nothing entered
View Single Post
 
Old 01-31-2017, 05:06 PM
Brittni Brittni is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jan 2017
Posts: 2
Brittni is on a distinguished road
Default 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")))))
Reply With Quote