Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have to IF Functions that work independently and I am trying to combine
them into one function. My desired end result is either the text "BUY" or "SELL". 1st Function - IF(AND($B$13="High",$I$13="S"),"SELL","") If cell B13 has the text "High" and I13 has the text "S", then generate the word "SELL". If this is false, then leave the cell blank. 2nd Function - IF(AND($C$9="Low",$I$9="L"),"BUY","") If cell C13 has the text "low" and I13 has the text "L", then generate the word "BUY". If this is false, then leave the cell blank. Issue - Combine these 2 independently working functions. Desired result when combined is either "BUY", "SELL", or blank. What I tried: OR(IF(AND($B$17="High",$I$17="S"),"SELL",""),IF(AN D($C$17="Low",$I17="L"),"BUY","") Result a #VALUE! Error This is really a circular reference error as I want the true result of these 2 nested IF functions to be displayed. I just do not know how to do it. OR(IF(AND($B$17="High",$I$17="S"),"SELL",""),IF(AN D($C$17="Low",$I17="L"),"BUY",""), show the true result - "BUY", "SELL" or blank. I hope this makes sense. Any help is appreciated. Regards, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF Function returns #NAME? Error | Excel Worksheet Functions | |||
Nested IF error | Excel Worksheet Functions | |||
Nested IF error | Excel Discussion (Misc queries) | |||
3 nested IFs causes error | Excel Worksheet Functions | |||
Nested IF AND OR function Inexplicable error | Excel Worksheet Functions |