How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?
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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
"Brett" <[email protected]> wrote:
> How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks