If/Then formula looking at fallouts not between 0 to 1




I'm trying to develop a function to return an statement that does
meets a certain criteria.See below:

if the number is >= zero and <=1, "statement 1"
then "statement 2".

i will be looking at time fields to determine if tow certain tasks
were completed within 1hr but not prior to.

thank you in advance.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

yes / no formulas into 1/0 3
Formula for 0 4
=SUBSTITUTE(;0;;1) 6
Looking for formula 2
Looking for a Formula 2
IF formula problems with "0" 13
Averages formula/0 7
Formula returns 0 1