3 Replies - 866 Views - Last Post: 01 August 2011 - 10:37 AM Rate Topic: -----

#1 Ellicode  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 04-July 11

Help with If statement in microsoft Excel 2010

Posted 26 July 2011 - 11:43 PM

=IF(H2=”This is a test”,"9999, All” )


i want to make it so if H2 has "this is a test" inside the cell, it will set the value of a cell to "9999, All"...
i used this guide here http://www.addictive...-and-functions/ but its giving me an error
help please :)!

Is This A Good Question/Topic? 0
  • +

Replies To: Help with If statement in microsoft Excel 2010

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 571
  • View blog
  • Posts: 2,979
  • Joined: 19-May 09

Re: Help with If statement in microsoft Excel 2010

Posted 29 July 2011 - 05:11 PM

Some rules to follow to get answers: please post the relevant code that you have written. Please state the exact line that is causing the error. Please say exactly what the error is.

Otherwise, you're asking us to use our psychic powers to figure out your problem, and not all of us have them. :)
Was This Post Helpful? 0
  • +
  • -

#3 guyfromri  Icon User is offline

  • D.I.C Addict

Reputation: 46
  • View blog
  • Posts: 805
  • Joined: 16-September 09

Re: Help with If statement in microsoft Excel 2010

Posted 29 July 2011 - 06:44 PM

That's not VBA, that's an excel formula....
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 571
  • View blog
  • Posts: 2,979
  • Joined: 19-May 09

Re: Help with If statement in microsoft Excel 2010

Posted 01 August 2011 - 10:37 AM

Whoops, very true RI. Ok, Ellicode, you have to provide another value for when H2 does NOT contain the string "This is a test." The syntax of the IF function in Excel is IF(condition, value if true, value if false). You're leaving out the value if false.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1