How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?
B Bob Phillips Jan 9, 2005 #2 What is the definition of day and night. Let's says day is 06:00 to 18:00, then assuming A2 is just time =IF(OR(A2<--"06:00:00",A2>=--"18:00:00"),25,16.5) -- HTH RP (remove nothere from the email address if mailing direct)
What is the definition of day and night. Let's says day is 06:00 to 18:00, then assuming A2 is just time =IF(OR(A2<--"06:00:00",A2>=--"18:00:00"),25,16.5) -- HTH RP (remove nothere from the email address if mailing direct)
J JE McGimpsey Jan 9, 2005 #4 If "day" is, say 6:00 am to 5:59 pm, One way: =CHOOSE(2*MOD(A2+0.25,1)+1,16.5,25)
