From: DonaMil on
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.
From: Eduardo on
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.