- If Statement Excel
- Nesting More Than 7 IF Statements in an Excel Function » How-To - Excel
- Excel - IF function with multiple words [Solved] » Forum - Excel
- Excel - Use the IF statement with Data Validation » How-To - Excel
- Apply an IF Function Using Dates and Text » How-To - Excel
- Excel - Using IF statement to add 1 to total » How-To - Excel

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:-

I hope that this helps.

Cheerio,

vcoolio.

- Member requests are more likely to be responded to.
- Members can monitor the statuses of their requests from their account pages.
- A CCM membership gives you access to additional options.