I need help writing a formula please

Question

&nbsp;&nbsp;I need A5 to subtract B5 and C5&nbsp; (and D5 only if value in E5 is "0") and provide the difference in F5&nbsp;All in the same formula.&nbsp;I intend to copy the formula down the column.&nbsp;Please.&nbsp;

riny_van_eekelen · Answer

animaltraceminerals&nbsp;That could be:=B5-C5-D5*(E5=0)&nbsp;

sergeibaklan · Answer

Riny_van_Eekelen&nbsp;
Perhaps misprint
=A5-B5-C5-D5*(E5=0)

riny_van_eekelen · Answer

SergeiBaklan&nbsp;Perhaps I indeed missed the A5 at the beginning. Wasn't entirely sure how to interpret the question. I read is so that the result would be in A5.

animaltraceminerals · Answer

Riny_van_Eekelen&nbsp;Actually, It didn't work.&nbsp;

riny_van_eekelen · Answer

animaltraceminerals&nbsp;Can you show the error? Upload the workbook or a screenshot that shows the formula and the result.

Forum Discussion

I need help writing a formula please

7 Replies

Resources