Formulas
 

I am trying to create a formula where cell A is one number and I was cell b
to be 2 times that amount but not higher then X so say Cell a has 125000
so cell B would be 250000 if it was 2 times the number, but if the highest
number is 200000 how would I do that?

Formulas
 

=MIN(A1*2,200000)

Vaya con Dios,
Chuck, CABGx3


"KJB61" wrote in message
...
I am trying to create a formula where cell A is one number and I was cell
b
to be 2 times that amount but not higher then X so say Cell a has
125000
so cell B would be 250000 if it was 2 times the number, but if the
highest
number is 200000 how would I do that?

Formulas
 

try this:
=MIN(A1*2,200000)

"KJB61" wrote:

I am trying to create a formula where cell A is one number and I was cell b
to be 2 times that amount but not higher then X so say Cell a has 125000
so cell B would be 250000 if it was 2 times the number, but if the highest
number is 200000 how would I do that?