If formula problems

C

Canon

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

RagDyeR

Another way:

=D20-ABS(D19)
--

HTH,

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


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return 0.00 if Neg. 3
[newbie] financial accounting problem 1
CONDITIONAL FORMATTING 1
Quick Sumproduct vs Text return 3
Text in a IF formula 6
Changing formulas that won't "formulate" 8
Divide within the same cell 2
goto function in macro 2 5

Top