Let me explain further:
I want to take the results of this:
=SUM(IF('Sale Data'!$F$7:'Sale Data'!$F$10537='Sale Data'!$B$2,INDEX('Sale Data'!$J$7:'Sale Data'!$P$10537,0,MATCH('Sale Data'!J$6,'Sale Data'!$J$6:'Sale Data'!$P$6,0))))/16
Which equals $90.46,
And the resutls of this:
=SUM(IF($A$7:$A$10537=$B$4,INDEX($J$7:$P$10537,0,MATCH(J$6,$J$6:$P$6,0))))
Which equals $537.03
and say,
=IF(('Sale Data'!C4-'Sale Data'!C3)/'Sale Data'!C4>A1,'Sale Data'!C4,0)
Where a1 is where I enter a percentage
and have the cell I type this in display the answer.
Hope this isn't too confusing!!