=IF statement
 

I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance

Hi Dick

here's some examples of how to use the IF function
=IF(A110,A1,B1)
displays the values in the cell references

=IF(A110,2,5)
displays the values 2 (if true) or 5 (if false)

=IF(A110,A1*1.1,A1*1.05)
if true, displays the value of A1 plus 10%, if false displays the value of
A1 plus 5%

=IF(A110,"Good","Bad")
returns the text values Good or Bad.

=IF(A110,IF(A120,"Very Good","Good"),IF(A15,"Bad","Shocking"))
nested IF to return the values of Very Good (if over 20), Good (if over 10),
Bad (if over 5) and Shocking if 5 or under.

Hope this gives you a bit of an idea of the different ways an IF function
can be used.

Regards
julieD


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance

Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance

Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:

Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance

Julie I know how to use it but I don't get numbers there only TRUE or False
Maybe I can send you the spreadsheet and you can try it yourself
Dick

"JulieD" wrote:

Hi Dick

here's some examples of how to use the IF function
=IF(A110,A1,B1)
displays the values in the cell references

=IF(A110,2,5)
displays the values 2 (if true) or 5 (if false)

=IF(A110,A1*1.1,A1*1.05)
if true, displays the value of A1 plus 10%, if false displays the value of
A1 plus 5%

=IF(A110,"Good","Bad")
returns the text values Good or Bad.

=IF(A110,IF(A120,"Very Good","Good"),IF(A15,"Bad","Shocking"))
nested IF to return the values of Very Good (if over 20), Good (if over 10),
Bad (if over 5) and Shocking if 5 or under.

Hope this gives you a bit of an idea of the different ways an IF function
can be used.

Regards
julieD


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance

Hi Dick

yep, send it to me as this doesn't make much sense (julied_ng at hcts dot
net dot au)

Regards
JulieD

"Dick" wrote in message
...
Julie I know how to use it but I don't get numbers there only TRUE or
False
Maybe I can send you the spreadsheet and you can try it yourself
Dick

"JulieD" wrote:

Hi Dick

here's some examples of how to use the IF function
=IF(A110,A1,B1)
displays the values in the cell references

=IF(A110,2,5)
displays the values 2 (if true) or 5 (if false)

=IF(A110,A1*1.1,A1*1.05)
if true, displays the value of A1 plus 10%, if false displays the value
of
A1 plus 5%

=IF(A110,"Good","Bad")
returns the text values Good or Bad.

=IF(A110,IF(A120,"Very Good","Good"),IF(A15,"Bad","Shocking"))
nested IF to return the values of Very Good (if over 20), Good (if over
10),
Bad (if over 5) and Shocking if 5 or under.

Hope this gives you a bit of an idea of the different ways an IF function
can be used.

Regards
julieD


"Dick" wrote in message
...
I have a column of numbers that I am trying to perform =IF statement on.
I
keep getting TRUE or FALSE in my cells. How do I actually get the
number
there instead of the TRUE or FALSE

Thank you in advance

What is your formula, and what values are in the cells that the formula
refers to?

Dick wrote:
Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:


Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Dick" wrote in message
...

I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debre here is the formula. =IF(O1,O1=100,O1+O1*.05)
All I am doing is applying it to a column of numbers, I can send the
spreadsheet but I will need your email. I don't think I can attach it here
Dick

"Debra Dalgleish" wrote:

What is your formula, and what values are in the cells that the formula
refers to?

Dick wrote:
Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:


Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Dick" wrote in message
...

I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Your formula says:

If there is something in cell O1
Then whatever is in cell O1 is greater than or equal to 100
(this part will result in either TRUE or FALSE)
Otherwise add the contents of cell O1 and O1*.05

What do you really want the formula to do?

For example, you could change the formula to:

=IF(O1=100,O1*1.05,O1)

That formula says:

If whatever is in cell O1 is greater than or equal to 100
Multiply O1*1.05
Otherwise, return O1

Dick wrote:
Debre here is the formula. =IF(O1,O1=100,O1+O1*.05)
All I am doing is applying it to a column of numbers, I can send the
spreadsheet but I will need your email. I don't think I can attach it here
Dick

"Debra Dalgleish" wrote:


What is your formula, and what values are in the cells that the formula
refers to?

Dick wrote:

Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:



Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Dick" wrote in message
...


I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

OK I tried that and Now all I get is VALUE in the cell, still no numbers


"Debra Dalgleish" wrote:

Your formula says:

If there is something in cell O1
Then whatever is in cell O1 is greater than or equal to 100
(this part will result in either TRUE or FALSE)
Otherwise add the contents of cell O1 and O1*.05

What do you really want the formula to do?

For example, you could change the formula to:

=IF(O1=100,O1*1.05,O1)

That formula says:

If whatever is in cell O1 is greater than or equal to 100
Multiply O1*1.05
Otherwise, return O1

Dick wrote:
Debre here is the formula. =IF(O1,O1=100,O1+O1*.05)
All I am doing is applying it to a column of numbers, I can send the
spreadsheet but I will need your email. I don't think I can attach it here
Dick

"Debra Dalgleish" wrote:


What is your formula, and what values are in the cells that the formula
refers to?

Dick wrote:

Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:



Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Dick" wrote in message
...


I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Make sure you used the letter oh and the number zero correctly in that formula:
=IF(o1=100,o1*1.05,o1)

And when I had a number in O1, it worked fine for me.


Dick wrote:

OK I tried that and Now all I get is VALUE in the cell, still no numbers

"Debra Dalgleish" wrote:

Your formula says:

If there is something in cell O1
Then whatever is in cell O1 is greater than or equal to 100
(this part will result in either TRUE or FALSE)
Otherwise add the contents of cell O1 and O1*.05

What do you really want the formula to do?

For example, you could change the formula to:

=IF(O1=100,O1*1.05,O1)

That formula says:

If whatever is in cell O1 is greater than or equal to 100
Multiply O1*1.05
Otherwise, return O1

Dick wrote:
Debre here is the formula. =IF(O1,O1=100,O1+O1*.05)
All I am doing is applying it to a column of numbers, I can send the
spreadsheet but I will need your email. I don't think I can attach it here
Dick

"Debra Dalgleish" wrote:


What is your formula, and what values are in the cells that the formula
refers to?

Dick wrote:

Nick I have all the arguments correct but for the life of me I don't get the
values only TRUE or FALSE
Maybe I can send you the spreadsheet and see what you come up with


"Nick Hodge" wrote:



Dick

Paste the formula you have

IF uses the syntax

=IF(Test,Do_This_If_True,Else_Do_This)

Do you have all three arguments?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Dick" wrote in message
...


I have a column of numbers that I am trying to perform =IF statement on. I
keep getting TRUE or FALSE in my cells. How do I actually get the number
there instead of the TRUE or FALSE

Thank you in advance





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



--

Dave Peterson