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

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)


"Brett" wrote in message
...
How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?

Hi,

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

Ola

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

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




In article ,
"Brett" wrote:

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