Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculated Textbox not showing proper results. | Excel Discussion (Misc queries) | |||
How to increase calculations speed in pivot table with calculated fields & items | Excel Discussion (Misc queries) | |||
Can Function results be calculated? | New Users to Excel | |||
Can I do calculations on already calculated fields in a pivot tabl | Excel Discussion (Misc queries) | |||
Calculated Fields showing error results | Excel Discussion (Misc queries) |