Type A Question

[Guest]

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

 

[Bob Phillips]

Without context, that seems impossible to answer to me. B13, E4, D4, B15 are
just cells, they could be meant to represent anything. And there must be a
reason why the B cells are absolute, but the others aren't, but there is
nothing in the formula per se to indicate it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

I'll take Cryptic Questions from OnLine Courses for $200, Alex.

Could you give us the EXACT question or directions given in the online
course? A quote from the page, perhaps. Also, if there's a topic or
particular area they are focusing on, that might be helpful to know.

 

[vitruvian]

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

 

[Guest]

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'.

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