Допоможіть, будь ласка! Даю 100 балів
Ответы
Ответ:
To calculate the commission rate for the total sale for order 1 using an IF function in cell H10, you can use the following formula:
`=IF(F10>$F$5,$G$5,IF(F10>$F$6,$G$6,0))`
This formula checks if the total sale (cell F10) is greater than the threshold level in cell F5. If it is, then it returns the commission rate from cell G5 (2%). If it's not greater than the threshold level in cell F5 but is greater than the threshold level in cell F6 (more than $5), then it returns the commission rate from cell G6 (1%). Otherwise, if it's less than or equal to $5, then no commission is paid and 0 is returned.
The formula uses absolute references to cells F5 and G5 so that when you copy and paste this formula to other cells in column H for other orders, these references will remain unchanged. The reference to cell F10 is a relative reference so that when you copy and paste this formula to other cells in column H for other orders, this reference will change accordingly.