Creating formula

  • Thread starter Thread starter mbe4966
  • Start date Start date
M

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
 
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
 
Back
Top