Question

I need help with creating an IF FUNCTION (Excel)

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!

Answer 1

=IF(D18>500;D18=0;D18*0,05)
"96.9335" Represents the 5% of ---> "$1,938.67"