There is no wealth value, please ask the function expert to answer for free, thank you ~ ~ I want to set a function formula in the excel table. How should I set it?
As shown in the figure,
Scheme 1: Allocated according to the landlord's intention.
C2=IF(B2=80，2000*0.8，IF(B2= 100，ROUND((20000-2000 * 0.8 * COUNTIF(B:B，80))/COUNTIF(B:B， 100)，0)，""))
Scheme 2: Distribution according to the total score 10.
D2 = ROUND(20000/SUM(B＄2:B＄ 1 1)，0)*B2