I have been told by my excel guru that I cant have the following info in one
formula. Using Excel 2003
Is this true people? Many thanks for thinking about it. X
What I am after is;

If cell A is "X or Y or Z" & cell B is Mon, Tues, Wed, Thurs or Fri then
multiply cell E by £15.00 but
If cell A is "X or Y or Z" & cell B is "Sat" then multiply cell E by £20.00
but
If cell A is "X or Y or Z" & cell B is "Sun" then multiply cell E by £25.00
but
If cell A is "V" & cell B is "Mon, Tues, Wed, Thurs or Fri" & cell C between
00:01 & 08:00 (time) then multiply cell E by £10.00 & cell D by £5 but
If cell A is "V" & cell B is "Mon, Tues, Wed, Thurs or Fri" & cell C between
08:01 & 18:00 (time) then multiply cell E by £12.00 but
If cell A is "V" & cell B is "Mon, Tues, Wed, Thurs or Fri" & cell C between
18:01 & 23:59 (time) then multiply cell E by £10.00 & cell D by £5.