I have 4 formulas (each that evaluate 2 conditions) - they each work individually; however, I need to combine them all into one formula to get what I am really looking for... is this possible, and if so, can anyone help me? Thanks in advance!
=IF(AND(B2>0,C2<0.05),"a"," ")
=IF(AND(B2>0,C2<0.01),"b"," ")
=IF(AND(B2<0,C2<0.05),"c"," ")
=IF(AND(B2<0,C2<0.01),"d"," ")
yes you can combine
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 05-28-2014 at 09:58 PM. Reason: sorry your AND's dont overlap was just going dyslexic when you wrote your formulas in your post
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Ah - yes, you're correct! I need to amend it to the following to get what I want, but your syntax helped me greatly - thank you so much!
=IF(AND(B2>0,C2<0.05,C2>0.01),"a",IF(AND(B2>0,C2<0.01),"b",IF(AND(B2<0,C2<0.05,C2>0.01),"c",IF(AND(B2<0,C2<0.01),"d"," "))))
not a problem
i had to re-read it several times
was wondering why i could never get D to come out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks