Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
hi,
I need to do a formula that covers the next conditions: Max= 5000 Total= 5700 Min = ??? if total < max, then min = total*0.06 if total = max, then min = total*0.06 if total max, then min = (max*0.06)+(total-max) thanx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel IRR calculation | Excel Worksheet Functions | |||
Excel Calculation | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
About Calculation of Excel | Excel Discussion (Misc queries) |