Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to create a cell that takes a total, and multplies it by 15%, however,
if the 15% is less than twenty, I want the amount to be 20. I.E.-- subtotal is $95.00, so 15% would be $14.25. However I want the cell to show$20.00. I.E.-- sutotal is $300.00, so 15% would be $45.00. I want the cell to show the $45.00. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if statement | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
=IF Statement formula or conditional formatting | Excel Worksheet Functions |