Formula HELP

[Guest]

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?

 

[Guest]

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

 

[Rick Rothstein \(MVP - VB\)]

I want a specific formula to read as: "if CELL1 is less than CELL2

=(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

 

[Guest]

I debated which way to go!

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