"If" and "then" formula's

  • Thread starter Thread starter Ana
  • Start date Start date
A

Ana

Hello,

I need help on how to make this work, I have two formula's
that I am using:

=SUM(a1-b1+(b1<a1)*10/24) Formula for within 24 hrs
scenerio

=SUM(a1-b1+(a1<=b1)*10/24) Formula for outside of 24 hour
scenerio

How can I get it inputed so it will automatically know
that "IF" it is outside the 24 hr scenerio to use the
second formula? I would greatly appreciate this help!
 
Ana said:
Hello,

I need help on how to make this work, I have two formula's
that I am using:

=SUM(a1-b1+(b1<a1)*10/24) Formula for within 24 hrs
scenerio

=SUM(a1-b1+(a1<=b1)*10/24) Formula for outside of 24 hour
scenerio

How can I get it inputed so it will automatically know
that "IF" it is outside the 24 hr scenerio to use the
second formula? I would greatly appreciate this help!
Click to expand...

Is this what you want?

=IF(a1<=b1,a-1b1+10/24,a1-b1+10/24)

Dave
dvt at psu dot edu
 
Oops - I transposed two characters in the formula. I hope that was obvious
to the OP. But just in case, instead of this:
=IF(a1<=b1,a-1b1+10/24,a1-b1+10/24)
Click to expand...

try this:

=IF(a1<=b1,a1-b1+10/24,a1-b1+10/24)

Dave
dvt at psu dot edu
 
Back
Top