| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula problems
=IF(D190,D20-D19,D20+D19)
-- Gary''s Student - gsnu200851 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problems | Excel Discussion (Misc queries) | |||
| formula problems | Excel Discussion (Misc queries) | |||
| Formula problems | Excel Discussion (Misc queries) | |||
| Formula problems | Excel Discussion (Misc queries) | |||
| formula problems | Excel Worksheet Functions | |||
Linear Mode
