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
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