Help with date formula

S

S S

1st question.

I have a formula in 2 cells which based on the data (dates) entered, works
out if 1 week or 2 weeks and calculates a (rental) cost.
It enters £150 up to June and £200 July- September.

=CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,200,"") This is returning N/A, should
be £150 or £200

=CHOOSE(MATCH(H7,{0;5;7;11},1),"",150,200,"") This returns £150 or £200
which is correct.

Can anyone see whats wrong with one of the formulas.


2nd question

How would I alter the above formula to take account if someone wants to rent
for a third week, I can see in the formula the months part and also the £s
part but cant work out how it is deciding if one or two weeks. (I got the
formula done for me)

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top