Hi I am having problems coming up with the correct formula for something that I thought would be straight forward.
using 3 cells - A1 , B1 , C1
I want to return a value of 1 in cell C1 only if all the following are true.
A1 is not blank
B1 is not blank
B1 is less than the value of A1
Otherwise it can return a 0 or false or nothing even.
This is what I have tried
=IF(ISNUMBER(A1),ISNUMBER(B1),B1<A1)*1
As it stands, C1 returns a value of 1 whether the value of B1 is bigger or smaller than A1, but it does recognize blanks
Could someone advise me as to what I need to change?
using 3 cells - A1 , B1 , C1
I want to return a value of 1 in cell C1 only if all the following are true.
A1 is not blank
B1 is not blank
B1 is less than the value of A1
Otherwise it can return a 0 or false or nothing even.
This is what I have tried
=IF(ISNUMBER(A1),ISNUMBER(B1),B1<A1)*1
As it stands, C1 returns a value of 1 whether the value of B1 is bigger or smaller than A1, but it does recognize blanks
Could someone advise me as to what I need to change?