Hi everybody
This is my first post, so please, don't kill me if it looks different then the ones you are used to.
I need to combine 3 conditions into 1 formula and just can't get the correct writting.
Hopefully you will be able to help me.
The formula needs to combine the following:
If G2 is 1 and H2 is 1 = No FSM
If G2 is 0 = no FSM
In all other cases it needs to be 57
I tried it with several combinations of =IF(AND...... =IF(AND(OR...... =IF(G2....(AND... but as said before, I did not get the correct result yet.
I very much appreciate if someone could help me!
Thanks a lot and best regards
Paolino
Try this:
=IF(OR(G2=0, AND(G2=1, H2=1)), "no FSM", 57)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
this is it!
Thank you!!!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks