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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:39 PM.