I have following 5 formulas,
Please see test file.
IF(AND(C2<4.5,D2>39),"H","") >>>>>>>Result in G:G
IF(AND(C2<10.5,C2>4,D2>24),"H","") >>>>>>>Result in H:H
IF(AND(C2<10.5,C2>4,D2<25),"V","") >>>>>>>Result in I:I
IF(AND(C2>10,D2<20,D2>-20,E2>39),"H","") >>>>>>>Result in J:J
IF(AND(C2>10,D2<20,D2>-20,E2<40),"V","") >>>>>>>Result in K:K
in a L:L I can get desise result by doing =G&H&I&J&K
How can I combine all formulas to the one formula?
Please see attached file.
Thanks.
Is it one formula?
Formula:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
you can combine with an OR
for H
=OR(AND(C2<10.5,C2>4,D2>24),AND(C2<10.5,C2>4,D2>24),(AND(C2>10,D2<20,D2>-20,E2>39)))
i'll work on all and edit here
=IF(OR(AND(C2<4.5,D2>39),AND(C2<10.5,C2>4,D2>24),(AND(C2>10,D2<20,D2>-20,E2>39))),"H",IF(OR(AND(C2<10.5,C2>4,D2<25),AND(C2>10,D2<20,D2>-20,E2<40)),"V",""))
Last edited by etaf; 03-15-2020 at 09:50 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Please try at L2
=IF(AND(C2<=4,D2<40),"",IF(OR(AND(C2>10,D2<20,E2<40),AND(C2<=10,C2>4,D2<25)),"V","H"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks