3 Formula Questions

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Hi, I have three Excel 97 formula questions:

1) Suppose I have a formula which yields a dollar value with a theoretically
infinite amount of decimal places, but I use column formatting to limit the
decimal places to two positions. For example, the formula:

=1/3

yields $0.33333333333333333333333333333

but I limit it to two places with column formatting:

$0.33

But I then am multiplying the above results times a fixed quantity. But I
need to multiply the fixed quantity times the two-place value, not the
infinite place value.

For example, I might need "5 times $0.33", NOT "5 times $0.33333333333".

So is there a formula which would round the $0.333333333 value to two
decimal places, so I can use the result in another formula?

2) How do I write a formula to yield a text value. For example,

=if(C3>5,C3*0.525,????????)

What I want to do is if C3 > 5, then multiply C3 by .525; otherwise, write
the word "VOID" in the cell.

Is there a formula that does this?

3) And finally, where can I learn about both basic and complex formulas for
Excel? I checked the Help menu, but that was of no help. And google just
produced results for pages listing complex formulas.

Thanks for any help!
 
Hi, I have three Excel 97 formula questions:

1) Suppose I have a formula which yields a dollar value with a theoretically
infinite amount of decimal places, but I use column formatting to limit the
decimal places to two positions. For example, the formula:

=1/3

yields $0.33333333333333333333333333333

but I limit it to two places with column formatting:

$0.33

But I then am multiplying the above results times a fixed quantity. But I
need to multiply the fixed quantity times the two-place value, not the
infinite place value.

For example, I might need "5 times $0.33", NOT "5 times $0.33333333333".

So is there a formula which would round the $0.333333333 value to two
decimal places, so I can use the result in another formula?
=ROUND(your_formula,2)



2) How do I write a formula to yield a text value. For example,

=if(C3>5,C3*0.525,????????)

What I want to do is if C3 > 5, then multiply C3 by .525; otherwise, write
the word "VOID" in the cell.

Is there a formula that does this?
Click to expand...

=IF(C3>5, C3*0.525, "VOID")



--ron
 
Julie,

For formulas, check out Walk's book, Excel 2003 Formulas ISBN: 0764540734

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob Phillips said:
Julie,

For formulas, check out Walk's book, Excel 2003 Formulas ISBN: 0764540734
Click to expand...

Thanks Bob for both of your answers! I am saving this post so I can look for
that book.

Julie
 
Regarding your last question... I suggest you go to:
http://homepage.ntlworld.com/noneley/
where you will find an Excel add-in which provides descriptions of all the
Excel functions. Additionally, other Excel websites are listed for more
Excel assistance if needed. I especially like Chip Pearson's website because
I can usually find an example there that uses functions which relate to my
problem.

Good luck

WDA

end
 
W. D. Allen Sr. said:
Regarding your last question... I suggest you go to:
http://homepage.ntlworld.com/noneley/
where you will find an Excel add-in which provides descriptions of all the
Excel functions. Additionally, other Excel websites are listed for more
Excel assistance if needed. I especially like Chip Pearson's website because
I can usually find an example there that uses functions which relate to my
problem.
Click to expand...

Thanks! That;'s an excellent site. I have bookmarked it already. :)
 
Back
Top