Report

If Statement Excel

Ask a question KoTTen 1Posts Saturday May 13, 2017Registration date May 13, 2017 Last seen - Last answered on May 15, 2017 at 12:43 AM by vcoolio
Hello!

Im a complete green at excell, maybe i just dont understand how the if statement work or im not that smart as i think :P

The thing i want to do is as followed: if A1 is Bigger then A2 Then replace A2 with A1

My formula: =IF(A1>A2;A1;A2)

I pasted this forumla at A2

if A1 is set to 300 then A2 still shows 0

The function i want to mimic is to store the highest value in A1 in A2.

Always greatful for answers!

With kind regards Kotten.
See more 
Helpful
+0
plus moins
Hello Kotten,

Excel won't allow you to place a result formula in a reference cell which is referenced in the result formula. You'll receive a "circular reference" error message and the result will always be 0.

Hence, you will need to place your formula in A3 or B3.

=IF(A1>A2,A1,A2)


I assume that you realise that the formula you have will give you the value of A2 if A1 is less than A2.

Thus, I would say that the following adjusted formula may be what you would need:-

=IF(A1>A2,A1,"")

I hope that this helps.

Cheerio,
vcoolio.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!