Thread
:
Need help creating formula for given data
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Need help creating formula for given data
One way
=MAX(7,7+IF(G31000,(G3-1000)*0.005))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Need Assistance! Please Help!"
m wrote in message
...
I have develped a spreadsheet to assist me in my stock trading. I have one
column that I need to set up to calculate the commission rate. It took me
a
couple of years to get the basic calculations information figured out back
in
1998 and it has helped me a great deal when used on all my accounts. But,
I
still lack the expertise in some calculation functions. I would greatly
appreciate anyones assistance. Given information follows:
Commision rate is equal to $7.00. If though by multiplying 5% of the total
price, that figure exceeds the $7.00 standard rate, then additional
commission is $0.005 per share that exceeds 1000 shares.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett