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

Improve this question

2 Answers 2

Reset to default
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

Improve this answer
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.

Improve this answer

You must log in to answer this question.

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