OK, so the syntax for the IF command is as follows:
=IF(LOGIC_TEST,TRUE,FALSE)
The syntax for AND is as follows:
=AND(logic1,logictest2) {if both are true, return true)
You can nest both them together, and you can nest multiple and.
So, you wish to have the following structure:
=IF(AND(AND(B1<7,B1>.59),c1-b1<1),0,1)
This is not an answer, but an instruction set so that you can learn how to manipulate formaula for yourself in the future, not just CUT and PASTE from here with no idea of what is happening!
BTW, I tested this, and if I place a 6 in B1 and a 7 in C1, and place this formula into D1, it returns a 1
Hav3 fun!
Rather than nesting I am testing each part of the formula and building it up in columns, once working in their individual components I will try and nest them. So far I have got this:
=IF(AND(A1<=12,A1>=7),1,0) In C1
=IF(AND((A1<18.9,A1>12),2,0) in D1
I can get this to work with basic numbers.
I have tried substituting 12 with 00:00 as I work in 24Hr clock, or 7 with 07:00 (when doing this I have added a $ sign in front of the cell reference) and I get an error message thrown back.
Any ideas please?
Thank you anyway, Simon
Any help greatly appreciated.
Thank you,
Simon