Ineed 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 !