IF command help

[Rhodestransit]

I want to know how to use if with this problem
I want to have a cell check cell UA3 for a specific name, if that name is found then it needs to add 0.5 to the cell
Example formula in cell a1, to check cell AU3 for a name if the certain name is found then add a value of 0.5 to the a1 cell.
I had =IF(AU3,JimmySmith)+0.5
But it returns 0.5 regardless if the cell has the name or not.
I need this a part of a payroll spreadsheet.

 

[VoG]

You would need Tools > Options > Calculation tab, set Iterations to 1 then in A1

=IF(AU3="JimmySmith",A1+0.5,A1)

but a VBA solution may be preferable.

 

[Rhodestransit]

Thanks, That works, do I have to change the iterations for more than one formula like this?
But it does return a value of 1?
and every time I change the name in the cell it adds another number.

 

[VoG]

It is a circular reference. That's why you must set Iterations to 1.

 

[Rhodestransit]

The issue im having is if I enter a name in a box then change it the number keeps increasing, it does not go back to a false setting.