Formula help please (Office XP)

[StephenPaul]

Good afternoon

I though this was quite simple but I must be doing something wrong somewhere

=IF(A11<20,D9=20,IF(A11>20,D9=A11,"")

Any help appreciated

Stephen

[HansV]

If you want to place a result in cell D9, you must put the following formula in cell D9 itself:
<code>
=IF(A11<20,20,IF(A11>20,A11,""))
</code>
The result will be
20 if A11 is less than 20
blank if A11 is equal to 20
the value of A11 if A11 is greater than 20

If you want something else please explain.

You cannot set the value of D9 by placing a formula in another cell.