Problems with IF formular

[ENTERTAIN]

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?

 

[Marcelo Branco]

Try

C1
=ISNUMBER(A1)*ISNUMBER(B1)*(B1<A1)

M.

 

[Michael M]

Try

=IF(AND(B1<A1,OR(A1<>"",B1<>"")),1,"")

 

[ENTERTAIN]

Try

Try
C1
=ISNUMBER(A1)*ISNUMBER(B1)*(B1<A1)

M.

Thanks Marcelo that worked perfect

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

M.