Newbie needs help with a formula

  • Thread starter Thread starter corlew1
  • Start date Start date
C

corlew1

Hi I am using Microsoft Office 2000. I am an exel beginner and I though
this would be an easy function to create, but I have spent severa
hours trying to do this with no luck. I have an excel spreadsheet wher
I would like a formula that would do the following:

If a text value in cell B2 has the text "FSL", then I would lik
excel to leave cell C2 blank. If cell B2 is has any other text in it
then I would like Excel to add the text value "N/A" to cell C2.

Thanks,

Jame
 
Hi Corlew1!

Here's three options all for C2

=IF(B2="FSL","","N/A")
Returns "" for FSL or fsl in B2 or the text N/A if anything else

=IF(B2="FSL","",NA())
Same but returns the Excel error message #N/A

=IF(EXACT(B2,"FSL"),"","N/A")
Returns "" only for FSL and not fsl
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top