From: DonaMil on 14 Apr 2010 11:14 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 14 Apr 2010 11:20 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.
|
Pages: 1 Prev: workday, networkday or something else? Next: multiple dependent drop down lists |