Thread
:
excel calculation
View Single Post
#
1
Posted to microsoft.public.excel.newusers
Shiblie Bshara
external usenet poster
Posts: 7
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
Reply With Quote
Shiblie Bshara
View Public Profile
Find all posts by Shiblie Bshara