Forum Discussion

AMB12345's avatar
AMB12345
Copper Contributor
Jun 06, 2022
Solved

Help for a formula

Hello! Is there some one who could give me the formula for this...   If D12>30 then D14=D12-D13+C14 If D12< or = 30 then D14=C14   Thanks for your help 🙂
excel
  • JoeUser2004's avatar
    JoeUser2004
    Jun 06, 2022

    AMB12345 

     

    Enter the following formula into D14:

     

    =IF(D12>30, D12-D13+C14, C14)

    or

    =IF(D12>30; D12-D13+C14; C14)

     

    The difference depends on whether you use comma or semicolon to separate parameters.

mtarler's avatar
mtarler
Silver Contributor
Jun 06, 2022
In D14 type: IF(D12>30, D12-D13+C14, C14)

Resources