ExcelBanter - Math Function?

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

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

- - Math Function? (https://www.excelbanter.com/excel-discussion-misc-queries/240526-math-function.html)

Doug

Math Function?

What function would I use in cell U207 to take cell S207 multiplied by -1 and
add it to cell T207
--
Thank you!

Jacob Skaria

Math Function?

=-S207+T207

If this post helps click Yes
---------------
Jacob Skaria

"Doug" wrote:

What function would I use in cell U207 to take cell S207 multiplied by -1 and
add it to cell T207
--
Thank you!

Dave Peterson

Math Function?

=t207-s207

or with minor checking...
=if(count(s207:t207)<2,"not enough numbers!",t207-s207)
or make the cell look empty
=if(count(s207:t207)<2,"",t207-s207)

Doug wrote:

What function would I use in cell U207 to take cell S207 multiplied by -1 and
add it to cell T207
--
Thank you!

--

Dave Peterson

T. Valko

Math Function?

Try this:

=SUM(-S207,T207)

--
Biff
Microsoft Excel MVP

"Doug" wrote in message
...
What function would I use in cell U207 to take cell S207 multiplied by -1
and
add it to cell T207
--
Thank you!

Mike H

Math Function?

Maybe this

=S207*-1+T207

Mike

"Doug" wrote:

What function would I use in cell U207 to take cell S207 multiplied by -1 and
add it to cell T207
--
Thank you!

p45cal[_45_]

Math Function?

doug;462940 Wrote:
what function would i use in cell u207 to take cell s207 multiplied by
-1 and
add it to cell t207
--
thank you!
=(s207*-1)+t207

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=128027

All times are GMT +1. The time now is 03:32 PM.