Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel calculation
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel calculation
Hi,
Try this =IF(B2B1,(B1*0.06)+(B2-B1),B2*0.06) Where B1= max B2= total Mike "Shiblie Bshara" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel calculation
The IF formula is good but you can also use an IF-less formula
With Max in A1 and Total in B1 =(B1*0.06)*(B1<=A1)+((A1*0.06)+(B1-A1))*(B1A1) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Shiblie Bshara" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |