help with date formula
 

if cell D7 = 5 or 6 then cell M7 to show 150
if cell D7 = 7 or 8 then cell M7 to show 200

The 5 6 7 8 refer to months ie May/June/July/August
The 150/200 are £s

Looking for formula to do the above

thansk

One way

Assuming inputs in D7 are dates

Put in M7:

=IF(D7="","",IF(OR(MONTH(D7)=5,MONTH(D7)=6),150,IF (OR(MONTH(D7)=7,MONTH(D7)=
8),200,"")))

Format M7 as currency (£)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Juco wrote in message
k...
if cell D7 = 5 or 6 then cell M7 to show 150
if cell D7 = 7 or 8 then cell M7 to show 200

The 5 6 7 8 refer to months ie May/June/July/August
The 150/200 are £s

Looking for formula to do the above

thansk

Hi

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

Arvi Laanemets


"Juco" wrote in message
k...
if cell D7 = 5 or 6 then cell M7 to show 150
if cell D7 = 7 or 8 then cell M7 to show 200

The 5 6 7 8 refer to months ie May/June/July/August
The 150/200 are £s

Looking for formula to do the above

thansk

thanks Arvi

that worked.

Juco

"Arvi Laanemets" wrote in message
...
Hi

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

Arvi Laanemets


"Juco" wrote in message
k...
if cell D7 = 5 or 6 then cell M7 to show 150
if cell D7 = 7 or 8 then cell M7 to show 200

The 5 6 7 8 refer to months ie May/June/July/August
The 150/200 are £s

Looking for formula to do the above

thansk