Simple but difficult-to-find formatting solutionClosed

Question

Please help.....!
I am working in Excel 2010 with a database of prospects.
I want a group of cells (in the same row) to show "n/a" if I enter "No" in a preceding cell.
The numerous video clips and support articles seem to deal with formatting by colour only.....how do I do this instead. As I say - simple but apparently very difficult.
Many thanks,
Neal.

ac3mark · Answer

Great question, I hope it is that easy.  The formula for if then logic is as follows:

=if(logic_test, true, false)

So with that being said, you could do something like:

=if(a1="no","NA","")

So what you are doing is checking cell A1 with the formala entered into what ever cell you want the NA to display.  If the cell does not contain NO, the cell displays nothing!

I hope this helps! 
 
"If you would have told me 20 years ago that everyone was going to be a photographer in 20 years, I wouldn't have believed you!"

Simple but difficult-to-find formatting solution

1 reply

Subscribe To Our Newsletter!