I am trying to create a formula in excel 2003 to show that unless D24 & D25 contain an x then G24 should be blank but if there are x’s then everything from B8 onwards in the latter part of the formula should follow and show a “Name a 1 or a 2" but it doesn't seem to do that.
=IF((AND(D24="x",D25="x")),G24,"",IF(B8="","",IF(C8="",B9,IF(C8="W",1,IF(C8="L",0))))
I hope there is sufficient info to correct this formula and if anyone can help I would be very grateful.
Last edited by alan_stephen75@; 10-04-2010 at 01:04 PM.
Are you entering the formula in G24... should it be more like:
=IF((AND(D24="x",D25="x")),"",IF(B8="","",IF(C8="",B9,IF(C8="W",1,IF(C8="L",0)))))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
My guess in G24
=IF(AND(D24="x",D25="x"),IF(B8="","",IF(C8="",B9,IF(C8="W",1,IF(C8="L",0)))),"")
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Many thanks, perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks