If Statement Excel

Closed
KoTTen Posts 1 Registration date Saturday May 13, 2017 Status Member Last seen May 13, 2017 - May 13, 2017 at 07:10 AM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 - May 15, 2017 at 12:43 AM
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.

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 260
May 15, 2017 at 12:43 AM
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.
0