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 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 15, 2017 at 12:43 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 15, 2017 at 12:43 AM
Related:
- If Statement Excel
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.