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! :)

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

  • 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 '13 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 '13 at 21:26
  • @Mordecaii Still working? – Kruug May 7 '13 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.