0

Like, what is the problem with it?

=IF(F2>6,=A18*0.5,=A18*0.6)

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

6

Try this:

=IF(F2>6,A18*0.5,A18*0.6)

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

3
  • 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
2

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.