Creating formula

[mbe4966]

I want to create a formula that will check two cells for values. If on
or the other has a value, then the value in the cell is multiplied b
the sum of two other cells. This is to calculate the cost of an ite
based on quantity and type. Example:

A1 B1 hold a quantity. Only one cell will have a value entered. If A
holds a value it is multiplied by the sum of the value in cells A36 an
C36. If B1 holds a value it is multiplied by the value in A36 and E36.

I am not a programmer and have tired different functions but canno
figure out to do this.

Th

 

[Frank Kabel]

Hi
try
=(A36+E36)*IF(ISNUMBER(A1),A1,IF(ISNUMBER(B1),B1,0))

 

[Bernie Deitrick]

mbe,

Since blanks are evaluated as zero, you could use this, if your are SURE
that A1 and B1 are NEVER filled at the same time:

=A1*(A36+C36)+B1*(A36+E36)

HTH,
Bernie
MS Excel MVP