| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| True Or False, no matter what... it still displays the false statement | Excel Programming | |||
Linear Mode
