View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shiblie Bshara Shiblie Bshara is offline
external usenet poster
 
Posts: 7
Default 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