Mudcat Café Message Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafeawe



User Name Thread Name Subject Posted
Tiger Tech: MS Excel 'IF' function - help requested (5) RE: Tech: MS Excel 'IF' function - help requested 28 Mar 03


A valuable tip is to do it stepwise, making sure it works each time. You could start with something like:

    =IF(AND(1=1,1=1,1=1,1=1),"YES","NO")

    make sure it works, then expand it to:

    =IF(AND(B5>46,1=1,1=1,1=1),"YES","NO")

    and so forth.
If you try to do it all at once, you'll never get there (but you know that already).

It can also help to create an intermediate result field encompassing half, or so, of the calculations - then a second operation performed on that intermediate field.

Keep it simple, do it stepwise, or debugging and checkout can be horrendous. If it's THAT complicated, how would you know the result was correct, anyway, without having something to hang your hat on?


Post to this Thread -

Back to the Main Forum Page

By clicking on the User Name, you will requery the forum for that user. You will see everything that he or she has posted with that Mudcat name.

By clicking on the Thread Name, you will be sent to the Forum on that thread as if you selected it from the main Mudcat Forum page.

By clicking on the Subject, you will also go to the thread as if you selected it from the original Forum page, but also go directly to that particular message.

By clicking on the Date (Posted), you will dig out every message posted that day.

Try it all, you will see.