Singletrack Mountain Bike Magazine

• Overview
• Bike Forum
• Chat Forum
• For Sale
• Wanted
• Forum Help
• Classified Rules

Chat Forum

1. Dibbs - Member

   I have three temperatures T1, T2 & T3. How do I write a formula to highlight if one of the temperatures is more than five degrees different to the others. I know I can just look at the three temperatures and see the difference in an instant, but I'm trying to write a formula to make it idiot proof (because I have been known to work with idiots)

   Cheers

   Posted 9 months ago #
2. mrmo - Member

   use an IF statement,

   Something like IF t1>t2+5, do x, IF t2>t1+5...

   just think of the combinations and should be good to go.

   Posted 9 months ago #
3. Stoner - Member

   use "Conditional Formatting" under "Format"

   depending on which one you want to be comparing to the other two (or both?) then assume you have columns A, B and C, in Column A set condition format to be:

   "Formula is" (from first drop down box)

   =OR(A1<(B1-5), A1>(B1+5), A1<(C1-5), A1>(C1+5))

   And set a format (that is different to the natural format) in the "format" button.

   that particular formula compares A with B and C for +/-5deg simultaneously. You can obviously change the logical test you want the highlighting to be based upon.

   Posted 9 months ago #
4. jam bo - Member

   Is the future nuclear safety of the uk really in the hands of STW?

   Posted 9 months ago #
5. The Southern Yeti - Member

   =IF(AND(MAX($J$7:$J$10)>=MIN($J$7:$J$10)+5,J7=MAX($J$7:$J$10)),"Attention","")

   Posted 9 months ago #
6. Dibbs - Member

   Thanks again.

   Posted 9 months ago #

RSS feed for this topic

Reply

You must log in to post.