True/False
 

I would like to set up a true/false formula. Here is what I am wanting to do:

If I the number 60 in G2 cell (miles) and want to use that to get a total in
E5 (using G2 * 3.00) = 180.00. How do I keep my total to be a minimum of
180.00 even if the mileage is 30. But if my mileage is 80, I would like it
to increase to 240.00.

Thank You!!

True/False
 

=IF(G2*3<180,180,G2*3)
--
Mike Q.


"Heather" wrote:

I would like to set up a true/false formula. Here is what I am wanting to do:

If I the number 60 in G2 cell (miles) and want to use that to get a total in
E5 (using G2 * 3.00) = 180.00. How do I keep my total to be a minimum of
180.00 even if the mileage is 30. But if my mileage is 80, I would like it
to increase to 240.00.

Thank You!!

True/False
 

=if(G2=0,0,Max(180,G2*3))

--
Regards,
Tom Ogilvy


"Heather" wrote:

I would like to set up a true/false formula. Here is what I am wanting to do:

If I the number 60 in G2 cell (miles) and want to use that to get a total in
E5 (using G2 * 3.00) = 180.00. How do I keep my total to be a minimum of
180.00 even if the mileage is 30. But if my mileage is 80, I would like it
to increase to 240.00.

Thank You!!

True/False
 

Heather wrote:
I would like to set up a true/false formula. Here is what I am wanting to do:

If I the number 60 in G2 cell (miles) and want to use that to get a total in
E5 (using G2 * 3.00) = 180.00. How do I keep my total to be a minimum of
180.00 even if the mileage is 30. But if my mileage is 80, I would like it
to increase to 240.00.

Thank You!!

=IF(G2<60,"180",G2*3)

Hope this helps.