Multiply cells based on result of other cells

Copper Contributor

Hi everyone,


Looking for some help on a formula that will assist in the below, essentially looking to multiply I5 by F5 if there is a difference between C5 and E5.





2 Replies
best response confirmed by Hans Vogelaar (MVP)



This returns the intended result in my sheet.

multiply cells based on results of other cells.png

absolute legend @OliverScheurich, cheers!