I want a specific formula to read as: "if CELL1 is less than CELL2 then...
CELL1+2*(3.25)" or if CELL2 is less than CELL1 then...CELL2+2*(3.25)" I have
no idea how to use this function or how to type it in. Can anyone help me?
--
Mark

=(MIN(A1,B1)+2)*3.25

"mapberkley" wrote:

I want a specific formula to read as: "if CELL1 is less than CELL2 then...
CELL1+2*(3.25)" or if CELL2 is less than CELL1 then...CELL2+2*(3.25)" I have
no idea how to use this function or how to type it in. Can anyone help me?
--
Mark

I want a specific formula to read as: "if CELL1 is less than CELL2
then...
CELL1+2*(3.25)" or if CELL2 is less than CELL1 then...CELL2+2*(3.25)" I
have
no idea how to use this function or how to type it in. Can anyone help
me?

=(MIN(A1,B1)+2)*3.25

Your answer is more than likely what the OP wanted, but I feel constrained
to point out that the **math** of what the OP wrote would have dictated this
answer...

=MIN(A1,B1)+2*3.25

I feel you interpretation is correct because if the OP wanted it the way I
have shown, he wouldn't have left the 2*3.25 calculation pending.... he
would have simply multiplied it out and shown 6.5 instead.

Rick

I debated which way to go!

"Rick Rothstein (MVP - VB)" wrote:

I want a specific formula to read as: "if CELL1 is less than CELL2
then...
CELL1+2*(3.25)" or if CELL2 is less than CELL1 then...CELL2+2*(3.25)" I
have
no idea how to use this function or how to type it in. Can anyone help
me?

=(MIN(A1,B1)+2)*3.25

Your answer is more than likely what the OP wanted, but I feel constrained
to point out that the **math** of what the OP wrote would have dictated this
answer...

=MIN(A1,B1)+2*3.25

I feel you interpretation is correct because if the OP wanted it the way I
have shown, he wouldn't have left the 2*3.25 calculation pending.... he
would have simply multiplied it out and shown 6.5 instead.

Rick