Answer :
which uses a simple IF function in Excel to return 15% as 0.15 if B6 is greater than or equal to 20,000, or 3% as 0.03 otherwise.The correct formula for cell B8 is A) =IF(B6>=20000, 0.15, 0.03),
To determine the correct formula to be entered in cell B8 that returns a value of 15% if the value in cell B6 is greater than or equal to 20,000, or returns 3% otherwise, one can use the simple IF function in Excel. The correct formula is A) =IF(B6>=20000, 0.15, 0.03). This formula checks the condition in B6 and uses arithmetic to calculate the percentage. If B6 contains a value of 20,000 or more, the formula returns 0.15, representing 15%. If the value is less than 20,000, the formula returns 0.03, which represents 3%. Note that percentages in Excel formulas should be written as decimals.
The correct formula for cell B8 is A) =IF(B6>=20000, 0.15, 0.03),
