View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Koneko Koneko is offline
external usenet poster
 
Posts: 1
Default 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!!