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 1371 Registration date Thursday July 24, 2014 Status Moderator Last seen April 12, 2023 - May 15, 2017 at 12:43 AM
vcoolio Posts 1371 Registration date Thursday July 24, 2014 Status Moderator Last seen April 12, 2023 - May 15, 2017 at 12:43 AM
Related:
- If Statement Excel
- Excel if statement increment by 1 - Guide
- Excel date format dd.mm.yyyy - Guide
- Fenix internet on bank statement - Guide
- How many if statements can you nest - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 reply
vcoolio
Posts
1371
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
April 12, 2023
252
May 15, 2017 at 12:43 AM
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.
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.