Conditional Calculations with Calculated Results
 

Greetings!

I'm wanting to embed a calculation within a conditional formula/function.
The typical IF function is typically something like: =IF(E65000,"YES","NO")
read as "If cell E6 is greater than five thousand, then respond yes, if not
respond no."

The next step I am trying to do is have it do a calculation in place of
stating "yes." For example: If cell E6 is greater than five thousand, then
respond with the amount minus 5000, if not respond 0.

The logical function would seem to be something like:
=IF(F7=YES,(E7-5000),0) However, this is not working for a number of
reasons. Basically, I see an "if, then" function, but am not familiar with
Excel enough to know of another appropriate function for what I am seeking.

What function would be best for this and how would I go about entering it?

Thanks!!

Conditional Calculations with Calculated Results
 

You've changed to a different row for your second formula, but you can
do this directly on your first:

=IF(E65000,E6-5000,0)

Another way to do it would be:

=MAX(0,E6-5000)

but that might confuse you more !!

Hope this helps.

Pete

On Mar 28, 11:01*pm, Koneko wrote:
Greetings!

I'm wanting to embed a calculation within a conditional formula/function. *
The typical IF function is typically something like: =IF(E65000,"YES","NO")
read as "If cell E6 is greater than five thousand, then respond yes, if not
respond no." *

The next step I am trying to do is have it do a calculation in place of
stating "yes." *For example: *If cell E6 is greater than five thousand, then
respond with the amount minus 5000, if not respond 0. *

The logical function would seem to be something like:
=IF(F7=YES,(E7-5000),0) * However, this is not working for a number of
reasons. *Basically, I see an "if, then" function, but am not familiar with
Excel enough to know of another appropriate function for what I am seeking..

What function would be best for this and how would I go about entering it? *

Thanks!!