Forum Discussion
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 🙂
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.
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.
Your formula =IF(D12>30; D12-D13+C14; C14) works.
Thank you so much 🙂
Thank you so much 🙂