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, 08:17 PM

jeffreybrown jeffreybrown is offline

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

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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

« 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 11:35 AM.