Updating an existing formula to override current logic

[bdav1216]

Hello,

My current formula is outputting the value of a cell from another sheet OR a '-' if not found.

=IF(SHEET1!$AP$1=0,"-",SHEET1!$AP$1)

If Column L = '1', I would like to update the above formula to say 'AUTOMATED' regardless if there is a value present.

How would I go about doing that?

[Sam Capricci]

perhaps this... =IF(SHEET1!L1=1,"AUTOMATED",IF(SHEET1!$AP$1=0,"-",SHEET1!$AP$1))
your post is marked as solved, you might want to remove that unless you solved it.
AND, you have L='1' so I am making the assumption it is numeric not a text value and it is in cell L1.
AND also, I don't know if you want it to be an absolute cell reference or not so make it SHEET1!$L$1 if you want it absolute.