1
I have the following formula below:
=IF(ISBLANK(D5),MULTIPLY(C5:D5),"0.00")
I'm not exactly sure what I'm doing wrong here or if I even can (I don't know much about Google Sheets formulas at all....) but basically, I want E5 to equal C5*D5, and if D5 is empty, I want E5 to equal 0. any help is greatly appreciated! Thanks in advance all!!!
2You must swap operands 2 and 3. – Akina – 2019-09-13T04:49:00.160
That did it! Thanks Akina!! – Johnny Heisler – 2019-09-14T03:55:33.870