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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 15, 2017 at 12:43 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 15, 2017 at 12:43 AM
Related:
- Excell if statements
- How many if statements can you nest in excel - Guide
- Excel if color - Guide
- Excel if statement with text - Guide
- Excel if statements with dates - Guide
- If iserror excel - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.
