Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Help solving this equation
=IF((SUMIF(K25,"<0",K25))then(K25+P22+P21))*orIF(( SUMIF(K25,"0",K25))then(K25-(P22+P21)))
i am familiar with VBA a little... i understand the "or if" command is not in excel i just put it in so you guys could understand what i am trying to accomplish. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help solving this equation
=IF((SUMIF(K25,"<0",K25))then(K25+P22+P21))*orIF(( SUMIF(K25,"0",K25))then(K25-(P22+P21)))
i am familiar with VBA a little... i understand the "or if" command is not in excel i just put it in so you guys could understand what i am trying to accomplish. Firstly, this is *not* VBA! Secondly, you can use the OR() function in cell formulas. Look it up and see what it does and how it works. Thirdly, I can't give you a sample formula because I can't make sense of this example's use of the SUMIF() function. If using XL2007 or later perhaps the SUMIFS() function would better suit your needs! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help solving this equation
"DeerSpotter" wrote:
=IF((SUMIF(K25,"<0",K25))then(K25+P22+P21)) *orIF((SUMIF(K25,"0",K25))then(K25-(P22+P21))) i understand the "or if" command is not in excel i just put it in so you guys could understand what i am trying to accomplish. Does this do what you want? =IF(K25<0, K25+P22+P21, K25-(P22+P21)) Note: You do not cover the case when K25=0. As written, my formula will return -(P22+P21) in that case. If you to return P22+P21, change K25<0 to K25<=0. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solving for a sum | Excel Worksheet Functions | |||
solving of linear equation | Excel Discussion (Misc queries) | |||
Please help me solving this equation ...: ) | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Multi-variable Equation Solving | Excel Programming |