Help please with formula

  • Thread starter Thread starter S S
  • Start date Start date
S

S S

This is the formula I am using...

=CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,200,"")

A set of dates are entered 1st july to 15 July (dates before this would be
£150)

It should return in say A1 £200
It should return in sat A2 £200

In A1 I am getting #N/A

Can anyone spot the error as I dont understand it.
 
Date in D7 I assume?

there is nothing in the formula to compare a date, so it will always return
4 from MATCH, which will get "" from the list.

Where did you get this from?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 
Back
Top