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:
Which equals $537.03
=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.
Yes I could, but the problem is their will be tons of these cells and I didn't want to have to duplicate the "tons" *2!
The $90.46 is the average of all stores
The $537.03 is the total of store 1
I want to be able to have the user type a percentage in cell a1 and have the figure of the stores show the amount if it is <or> the percentage of the chain based on the percentage typed in cell a1.