Help for a formula

[AMB12345]

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 :)

[#2 · Accepted solution]

@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.

[#3]

In D14 type: IF(D12>30, D12-D13+C14, C14)

[#4]

Your formula =IF(D12>30; D12-D13+C14; C14) works.
Thank you so much :)