I have numbers in cells and I am trying to add them up if they meet a certain criteria. Say for example I have sales numbers like
$500
$5000
$200
$2000
and I want to give $50 commision if sales is <$1000, but 5% if >$1000 how would I go about that..
So for example I should get a total of $450..($50+$250+$50+$100) for the above figures using the excel formula.
Thanks.
Duplicate here
http://www.excelforum.com/excel-form...statement.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thx Fotis.
Thread closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks