In: Computer Science
You want to calculate a bonus if the sold price was at least
equal to the listing price, and if the house sold within 30 days
after being listed.
In cell L12, insert an IF function with a nested AND function to
calculate a bonus. The AND function should ensure both conditions
are met: Sold Price divided by the Listing Price is greater than or
equal to 100% (cell L7) and the Days on Market are less than or
equal to 30 (cell L8). If both conditions are met, the bonus is
$1,000 (cell L9). Otherwise, the bonus is $0. Use mixed cell
references to the input values in the range L7:L9. Copy the
function to the range L12:L39.
In order to calculate the bonus as per the requirement, please use the below Excel formula. Please make sure to copy the formula as such including the "=" symbol. This formula can be pasted in the cell L12. Then copy the cell and paste it into other cells L12:L39.
=IF(AND(G12/F12 >=$L$7,J12<=$L$8)=TRUE,$L$9,0)
Here mixed cell references are used for cell L7, L8 and L9 such that when the formula is copied to L12:L39, these cell references are not shifted.
Please cross check that the cell formula looks like below in each cell when copy pasted.
In L12 it should be as below.
=IF(AND(G12/F12 >=$L$7,J12<=$L$8)=TRUE,$L$9,0)
In L13 it should be as below.
=IF(AND(G13/F13 >=$L$7,J13<=$L$8)=TRUE,$L$9,0)
and so on.