Re: Type A Question
- From: vitruvian@xxxxxxxxxxxxxxx
- Date: 6 Feb 2007 03:27:51 -0800
On Feb 4, 6:04 am, MGP31 <M...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am taking a course online about Excel. I would like to know how you would
type a question to find the definition for a result of a formula.
=IF($B$13*E4+D4>$B$15,$B$15-D4,$B$13*E4)
If have tried several methods in type a question to find this definition but
they do not work.
Any help would be appreciated.
Thank You
It's a true/false scenario
(I have reformatting/written so you can follow it easier)
=IF( [$B$13*E4+D4] > [$B$15] , [$B$15-D4] , [$B$13*E4] )
=IF([This Value] > [This Value] , then give me the true result I want
[This Value], otherwise give me the false value [This Value])
Alternatively, where you see the formula in the formula bar, click on
the fx to the left, as this will sometimes help you with understanding
a formula and what it is doing, you can also access help from here if
your cursor is in the formula name (such as the IF), and can take you
the relevant help article... Double clicking the cell will show you
all of the formula's references too which might help you
Hope this helps you
.
- Prev by Date: Re: 1 Million Rows ??
- Next by Date: Formula for figuring compound interest
- Previous by thread: Re: Type A Question
- Next by thread: Re: trying to store non-zero numbers from a list into sequential cells
- Index(es):
Relevant Pages
|
