Hi guys,
here is a question I have regarding a formula:
pink 65 $5
pink 42 $0
pink 0 $0
blue 87 $5
blue 63 $1
blue 5 $0
red 26 $0
red 4 $0
red 9 $0
For the first pink, blue or red which is over 50, you get $5 bonus. For the second one over 50, you get $1 bonus. If it is under 50 you don't get anything.
I need a formula which can give me the numbers in the C column automatically.
Thank you.
Last edited by scottylad2; 11-19-2010 at 04:24 PM.
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
This maybe:
=IF(B1>=50,CHOOSE(MIN(3,SUMPRODUCT(--($A$1:A1=A1),--($B$1:B1>=50))),5,1,0),0)
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks