Jump to content

Excel formula help please


Stuart
 Share

Recommended Posts

It's a basic if statement. Try and figure it out from there, if you still can't get it with that, come back for more help.

Thanks for that i knew it started with if, but the thing is im wondering if im looking for something like in webplus 10 where you get 'else' statements. Oh and i tried else and it didnt work!

Share this post


Link to post
Share on other sites

If I remember correctly...the way the if statements work in excel is ('some condition','what to do if true','what to do if false'). If you want if...else if, then you simply put the else if statement into the third term. Your statement is probably simply going to be ('blah < blah','yes','no' ) or something similar, play around with it and see if you can get what you want to work. :)

Share this post


Link to post
Share on other sites

Lol, this was a cinch! It's like I remember in GCSE ICT :lol:

 

Funny though, that 8 years later I am learning some seriously complicated Excel functions almost on a daily basis ... there aint nothing you can't do in Excel - I'm the Excel monkey!

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...