ExcelBanter - If formula problems

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If formula problems (https://www.excelbanter.com/excel-discussion-misc-queries/229957-if-formula-problems.html)

Canon

If formula problems

Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.

Gary''s Student

If formula problems

=IF(D190,D20-D19,D20+D19)
--
Gary''s Student - gsnu200851

Jarek Kujawa[_2_]

If formula problems

=IF(D19=<0,D20+D19,D20-D19)

On 6 Maj, 15:20, Canon wrote:
Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.

David Biddulph[_2_]

If formula problems

=D20-ABS(D19)
--
David Biddulph

"Canon" wrote in message
...
Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.

RagDyeR

If formula problems

Another way:

=D20-ABS(D19)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Canon" wrote in message
...
Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.

All times are GMT +1. The time now is 06:44 PM.