IF AND formula: replacing the FALSE Value with 0 when nothing entered

		Microsoft Office Forums > Microsoft Excel > Excel
IF AND formula: replacing the FALSE Value with 0 when nothing entered

FAQ

Thread Tools

Display Modes

01-31-2017, 05:06 PM

Brittni

Windows 7 32bit IF AND formula: replacing the FALSE Value with 0 when nothing entered

Office 2010 32bit

Novice

Join Date: Jan 2017

Posts: 2

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")))))

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 AM.