Solved using greater than or less than in an equation

February 10, 2016 at 19:00:40
Specs: Windows 7
i'm trying to solve if x is greater than 0.1 and less than 26 then 1, if not, then 0.
i tried 2 different ways:

=IF('Inputs & Assumptions'!P6>0.1,1,IF('Inputs & Assumptions'!P6<26,1,0))

however, when x is 0, the function is putting in a 1, instead of a 0.

very frustrating!


See More: using greater than or less than in an equation

Report •


#1
February 10, 2016 at 19:40:41
✔ Best Answer
You need to use the AND() function, try this:

=IF(AND('Inputs & Assumptions'!P6>0.1,'Inputs & Assumptions'!P6<26),1,0)

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
February 11, 2016 at 08:59:24
Thanks - that worked! now, can you teach me the lookup function?

jk - I'll try it on my own first......

Deb


Report •
Related Solutions


Ask Question