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 nested if statements in excel - Guide
- Excel if statement with text - Guide
- If date formula in excel - Guide
- Excel if cell contains date then return value - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
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.
