Exclude

[Michell Major]

=IF(K15="Private Job","S",IF(K15="",""))

I want it to return a void ("") for any other value in K15

 

[Pete_UK]

Try this:

=IF(K15="Private Job","S","")

Hope this helps.

Pete

 

[Roger Govier]

see reply to your question 14 clients