View Single Post
  #1   Report Post  
Juco
 
Posts: n/a
Default 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