Conditional Calculations with Calculated Results

[Koneko]

Greetings!

I'm wanting to embed a calculation within a conditional formula/function.
The typical IF function is typically something like: =IF(E6>5000,"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!!

 

[Pete_UK]

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

=IF(E6>5000,E6-5000,0)

Another way to do it would be:

=MAX(0,E6-5000)

but that might confuse you more !!

Hope this helps.

Pete