Forum Discussion

Michael1680's avatar
Michael1680
Copper Contributor
Oct 12, 2023

Multiply cells based on result of other cells

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.      
Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 12, 2023

    Michael1680 

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

    This returns the intended result in my sheet.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 12, 2023

Michael1680 

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

This returns the intended result in my sheet.

Resources