Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |