• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested if function

R

royalmain

New Member
Trying to get syntax right without luck here is what I am trying to do


-formula in G16 to check contents of C7

- if contents of C7 = " " G16="111 Winner"

- if contents of C7 ="L" G16 = C6 This is text

- if contents of C7 ="W" g16 = C7 this is also text


(formula would be modified for multiple cells in sheet resulting in tracking winners/losers as well as advising next game location)
 
Hi royalmain,


Welcome to the forums.


I have understood this far, if you could elaborate with an example it would be helpful. please use this:


=IF(C7=" ","111 Winner",IF(C7="L",C6,IF(C7="W",C7,"")))


Regards,
 
HAVE TRIED IT IN SEVERAL AREAS AND HAVE IT WORKING THANKS TO YOUR GUIDANCE


CELL REFERENCES ARE DIFFEENT DUE TO SHEET MOD BUT HERE IS WHAT WORKS:

=IF(D24="","117 WINNER",IF(D24="L",C25,IF(D24="W",C24)))


Many thanks for your assistance - as a novice user I had spent many hours trying this and that before reaching out for assistance - several library books only added to my confusion.
 
You must log in or register to reply here.
Back
Top