Try one of these entered in A2 then copied down as needed:

If you only have column B and C to deal with:

=11*(B2+C2)

If you have more than just 2 columns:

=11*SUM(B2:H2)

Where H2 represents the column for Sunday

--
Biff
Microsoft Excel MVP


"CharlieEcho561" wrote in message
...
Sheet should look something like this
a b c
1 Cost Monday Tue
2 11 1
3 22 2
4 11 1
5 33 2 1

SO, for each quantity in column b or c I want to multiply either/or with
11
to create the cost that days activity.

Is this sufficient clarification?

Shed
Shed2


"T. Valko" wrote:

Can you post an example with the desired result?

--
Biff
Microsoft Excel MVP


"CharlieEcho561" wrote in message
...
I am attempting to derive a number (cost) if eihter of the two adjacent
column cells have whole numbers. The cost factor is a constant 11. So
I
tried forcing the IF funcion then a combination of IF and OR but once I
suspect I got the formatting correct all I could get were alpha
characters
in
the cost column. Would someone please direct me how to get the numeric
number in the cost colum by multiplying either or both of the cells in
the
subsequent adjacent cells in the row?
Thanks
--
Shed2