Thread: If argument
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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.