more IF function

  • Thread starter Thread starter neilangelo
  • Start date Start date
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
 
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.


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
Click to expand...
to creating financial statements
 
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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
"<>" 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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
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.


------------------------------------------------



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