Type A Question
I'm thinking that maybe they're trying to get him to tell how he'd get Help
on the IF statement? Like:
click [Help] and type in
IF
or
IF worksheet function
but those aren't really 'questions'.
" wrote:
On Feb 4, 6:04 am, MGP31 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
|