more IF function

N

neilangelo

I just received help for my IF function question with the followin
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero
 
C

Chip Pearson

The <> comparison operator means 'not equal to'.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.
Click to expand...
to creating financial statements
 
A

Alan

No, its 'Not Equal' to zero
+,-,/,*
Add,Minus,Divide,Multiply
< Less than
More than
Click to expand...
= Equal to
<>Not equal to
neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.
Click to expand...
creating financial statements
 
M

Max

"<>" means "not equal to"
--
hth
Max
-----------------------------------------
Please reply in thread

Use xdemechanik <at>yahoo<dot>com for email
----------------------------------------------------------------------------
neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.
Click to expand...
creating financial statements
 
A

Alan

Forgot these two,
<= Less than or equal to
= More than or equal to
Click to expand...
Alan said:
No, its 'Not Equal' to zero
+,-,/,*
Add,Minus,Divide,Multiply
< Less than
More than
Click to expand...
= Equal to
<>Not equal to
neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.


------------------------------------------------
[/url]


~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
Click to expand...
 
J

John Wilson

neilangelo,

You should stick with the original thread.....

What does <>mean in the formula
It means "not equal to"

If A1 is not equal to 0 , (first comma is "then")
divide D1 by A1 , (second comma is "else") 0)

The quoted formula is from Alan's reply.
Basically it does whatever calculations can be accomplished.
If A1 = 1, B1 = 0 and C1 =2, it will divide D1/A1 and add it
to D1/C1 (it won't add in the result of D1/B1).
If that's what you want it to do, then use his suggestion.
If you want to return a zero result if either A1,B1 or C1 = 0
then use my suggestion in .newusers or Ron's suggestion.

John

neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.
Click to expand...
creating financial statements
 
P

Peo Sjoblom

It means not equal to, it makes sure you won't get div errors since if any
of A1, B1 and C are zero you'll get an error

--

Regards,

Peo Sjoblom

neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.
Click to expand...
creating financial statements
 
A

Alan

neilangelo,
You should stick with the original thread.....
Click to expand...

Agreed, and in one newsgroup only,
Alan.
John Wilson said:
neilangelo,

You should stick with the original thread.....

What does <>mean in the formula
It means "not equal to"

If A1 is not equal to 0 , (first comma is "then")
divide D1 by A1 , (second comma is "else") 0)

The quoted formula is from Alan's reply.
Basically it does whatever calculations can be accomplished.
If A1 = 1, B1 = 0 and C1 =2, it will divide D1/A1 and add it
to D1/C1 (it won't add in the result of D1/B1).
If that's what you want it to do, then use his suggestion.
If you want to return a zero result if either A1,B1 or C1 = 0
then use my suggestion in .newusers or Ron's suggestion.

John

neilangelo said:
I just received help for my IF function question with the following
solution

=IF(A1<>0,(D1/A1),0)+IF(B1<>0,(D1/B1),0)+IF(C1<>0,(D1/C1),0)

What does <>mean in the formula, is it greater than or equal to zero.


------------------------------------------------
[/url]


~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
Click to expand...
 
Top