I need help with creating an IF FUNCTION
In cell D19, use an IF function. The conditions are
• If the number in cell D18 is over 500, then insert 0.
• If the number in cell D18 is under 500, then insert
5% of the number in cell D18 (Hint: D18*.05).
When answering my question someone replied with this "=IF(D18>500,0.05*D18)"
Which equaled 96.9335 which is incorrect the answer should be $1,938.67
please help!
