Hello!
Please, can someone tell me how can I make formula for:
If D2 ; E2 ; F2 >= 4 and G2 >=5 , than H2 = 18, but IF D2 ; E2 ; F2 >= 4 and G2 >=7 , that H2 = 27. If any of these numbers are less than the condition, than H2 = 0 .
That would be unspeakably helpful for me !
Try this formula:
=IF(AND(D2>=4,E2>=4,F2>=4),IF(AND(G2>=5,G2<7),18,I F(G2>=7,27,0)),0)
Try this
Code:=IF(AND(D2>=4,E2>=4,F2>=4,G2>=7),27,IF(AND(D2>=4,E2>=4,F2>=4,G2>=5),18,0))
Last edited by Excel Fox; 04-22-2013 at 08:39 AM. Reason: Revised
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi Excel Fox,
I have tried this formula and it's giving only one result in multiple test which is 18. I think because of G2>=5 and G2>=7 conditons. Correct me if i am wrong.
Lalit, corrected it. It was because I used the smaller valued conditional first, rather than the larger one. Swapped it
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Another try:
=IF(AND(D2>=4,E2>=4,F2>=4),IF(G2>=7,27,IF(G2>=5,18 ,0)),0)
Another (slightly shorter) formula that appears to work...
=IF(OR(COUNTIF(D2:F2,"<4"),G2<5),0,18+9*(G2>=7))
None of these formulas are working for me ., but thanks anyways.
Formula given by me and by experts are based on what you have asked.
If it is not working then why don't share your file for better clearity.
Here is the file.
Posting Permissions
Reply With Quote
Bookmarks