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!

You need to use the AND() function, try this: =IF(AND('Inputs & Assumptions'!P6>0.1,'Inputs & Assumptions'!P6<26),1,0)

message edited by mmcconaghy

Thanks - that worked! now, can you teach me the lookup function? jk - I'll try it on my own first......

Deb

Ask Your Question

Weekly Poll