ExcelBanter - If argument

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If argument (https://www.excelbanter.com/excel-worksheet-functions/261520-if-argument.html)

DonaMil

If argument

I am looking to portray an argument that "if" a certain text is entered into
a given field then another field which is used as a calculation would return
an "NA" as it's entry.

Eduardo

If argument

Hi,
In the calculation field enter

=if(A1="your text","N/A",your formula)

"DonaMil" wrote:

I am looking to portray an argument that "if" a certain text is entered into
a given field then another field which is used as a calculation would return
an "NA" as it's entry.

All times are GMT +1. The time now is 01:14 PM.