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.
3 Replies
- In D14 type: IF(D12>30, D12-D13+C14, C14)
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 🙂
