I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means, if the value in cell I39 is greater than zero, multiply the value in I39 by the value in I40 and add to that the value in I39. If I39 is zero, do nothing.

On 3/07/2012 2:43 PM, Waa wrote:
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")




Hi

It is a logical statement, asking for an outcome governed by two conditions.

Condition one: =
IF I39 is greater than zero (0) then
Multiply the values in (I39 & I40) then
Add that total to the value in I39 again...

eg if I39 = 2 and I40 = 4 then the answer would be 10.

(2x4)+2) = 10 ..... (2x4=8)+2=10)

Condition two: =
If the I39 is Blank, then the result will be blank.

But it could be shortened to this as the first Sum statement is summing
a single cell instead of a range of cells.

=IF(I39="","",SUM((I39*I40)+I39))

So this effectively says:

If I39 is Blank, then your answer cell that has the formula will be blank.
Else
If it contains a number, then it processes the sum equation..

There is no need to include the 0 and the "" in the statement as one
negates the other because if there is no value in the cell it would be
blank, conversely, any value entered in the cell would trigger the event

HTH
Mick.

Mick,
I'm inclined to write that formula as follows...

=IF(LEN(I39),(I39*I40)+I39,"")
OR
=IF(NOT(I39),"",SUM(I39*I40,I39))

...for better clarity as opposed to checking I39<"" -OR- I39="",
respectively.<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Waa laid this down on his screen :
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

on 04-07-12, Bruno Campanini supposed :
Waa laid this down on his screen :
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

Sorry...

=IF(I390,I39*(1+I40),"")

Bruno

On Wed, 04 Jul 2012 21:55:46 +0200, Bruno Campanini
wrote:

on 04-07-12, Bruno Campanini supposed :
Waa laid this down on his screen :
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

Sorry...

=IF(I390,I39*(1+I40),"")

Bruno

What does that make you?

OOOoooof! That's got to suck, Bruno!
Perhaps now you'll think twice before replying with something so smug! :P

Spencer101 explained on 06-07-12 :
Chieftain of the Carpet Crawlers;1603427 Wrote:

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

Sorry...

=IF(I390,I39*(1+I40),"")

Bruno

What does that make you?[/i][/color]

OOOoooof! That's got to suck, Bruno!
Perhaps now you'll think twice before replying with something so smug!
:P[/i][/color]

Are you joking?

What is this formula:
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It makes the very same things of my formula:
=IF(I390,I39*(1+I40),"")

with the difference that you don't find here
some ridicolous things like Sum(I139)...

Sum(I139) = I139 even in your poor mathematics, etc.

Try to switch on your brain before speaking, may be
it can help, may be not.

Bruno

On 5/07/2012 5:55 AM, Bruno Campanini wrote:
on 04-07-12, Bruno Campanini supposed :
Waa laid this down on his screen :
I am new at excel and curious... please help.
The following formulea is used in our purchase orders -- what does it
mean?
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It means its author is a stupid man...

=IF(I390,I39*(1+I40))

Bruno

Sorry...

=IF(I390,I39*(1+I40),"")

Bruno


Bruno

People are here to help others, not debase, simply lay down your spin on
what you think will help the poster solve an issue and move on.

Perfection is one of life's biggest flaws, remember that when slagging
off someone who may know less than yourself...