SOLVED

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.

 

Michael1680_0-1697079994725.png

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Michael1680 

=IF(C5>E5,F5*I5,"")

This returns the intended result in my sheet.

multiply cells based on results of other cells.png

absolute legend @OliverScheurich, cheers!