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
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 <at>yahoo<dot>com
----
Juco <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
If the value in D7 is not a date but just a number then:
In M7 type: =IF(OR(D7=5,D7=6),150,IF(OR(D7=7,D7=8),200,""))
If you have various amounts for different months you might want to consider using the CHOOSE() function instead.
Hi
=CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,200,"")
Arvi Laanemets
"Juco" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:%23BD%[email protected]...
> Hi
>
> =CHOOSE(MATCH(D7,{0;5;7;9},1),"",150,200,"")
>
> Arvi Laanemets
>
>
> "Juco" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks