Formula help

[Guest]

How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?

 

[Bob Phillips]

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)

 

[Guest]

Hi,

Copy this to C2
=IF(A2="day",16.50,IF(A2="night",25.00,"?"))

Ola

 

[JE McGimpsey]

If "day" is, say 6:00 am to 5:59 pm, One way:

=CHOOSE(2*MOD(A2+0.25,1)+1,16.5,25)