This is the part I'm stuck on..

On the Transactions worksheet, click cell R9, and then press F2 to enter edit mode. Select "Everything Else", including the quotes, and replace it by entering an IF function that determines if the value in cell P9 is less than the value in cell K21 on the DataInputs worksheet. If the value is true, then the result is the value in cell I21 on the DataInputs worksheet. If the value is false, then the result is the value in cell I22 on the DataInputs worksheet. Be sure to use absolute references where necessary. Copy the formula through cell R30.

e03ch05_grader_pc_GolfSales_HottSamantha (version 1) [Autosaved] - Excel ? 6 - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Samantha Hott Calibri 11 - A" A" General Conditional Formatting Insert E - As $ - % " Paste BIU- B- - A- Format as Table X Delete 6:8 08 Cell Styles ~ Format Sort & Find & Filter * Select Clipboard G Font Alignment Number Styles Cells Editing K M N O R Calculated Fields Shift Coupon_Target |Coupon_Hit Coupon_Amt Retail Line_Item_Total Card_Charge Trans_Group Big_Ticket_Ite 9 Morning Local Coupon Match 0% $ 12.00 |5 36.00 O =IF(Transactions!P9