A formula puts a value into one cell.

In cell J4 you want the formula
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),12,"whatever you want the answer to be
if the AND condition isn't satisfied")
In K4 you want
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),4,"whatever you want the answer to be
if the AND condition isn't satisfied")
In L4 you want
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),4,"whatever you want the answer to be
if the AND condition isn't satisfied")
and so on.
--
David Biddulph


"fshewmkr" wrote in message
...
I want to be able to add across using a formula so that if cell c4 is 8R4OT
and cell d4 is 4S4R and cell e4 is 8V then cell j4 is 12 and cell k4 is 4
and
cell L4 is 4 and so on please help.