Like, what is the problem with it?


It keeps on making it just say =A18*0.5, not the actual contents of half of A18. So can someone try make this work?

All help appreciated! :)

2 Answers 2


Try this:


Source: http://office.microsoft.com/en-us/excel-help/if-function-HP010342586.aspx

  • Heh heh, I can't belive that worked. Thanks a lot! :) (I'll accept your answer later, it says I can only accept your answer in two minutes)
    – Mordecaii
    May 6, 2013 at 21:25
  • 1
    @Mordecaii I found it by looking up excel 2010 function inside if on Google, which returned this link: office.microsoft.com/en-us/excel-help/…. Your solution was found under Example 1.
    – Kruug
    May 6, 2013 at 21:26
  • @Mordecaii Still working?
    – Kruug
    May 7, 2013 at 19:00

As a general rule, the = sign is used only at the beginning of a formula, unless there is a comparison with the equal to operator, which is also a = sign.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .