ExcelBanter - Exclude

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Exclude (https://www.excelbanter.com/excel-discussion-misc-queries/114899-exclude.html)

Michell Major

Exclude

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

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

Pete_UK

Exclude

Try this:

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

Hope this helps.

Pete

Michell Major wrote:
=IF(K15="Private Job","S",IF(K15="",""))

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

Roger Govier

Exclude

see reply to your question 14 clients

--
Regards

Roger Govier

"Michell Major" wrote in
message ...
=IF(K15="Private Job","S",IF(K15="",""))

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

All times are GMT +1. The time now is 07:20 AM.