Simple but difficult-to-find formatting solution

Closed
nealmiddle
Posts
1
Registration date
Monday November 24, 2014
Status
Member
Last seen
November 24, 2014
- Nov 24, 2014 at 02:49 PM
 Blocked Profile - Nov 24, 2014 at 04:24 PM
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.

1 reply

Blocked Profile
Nov 24, 2014 at 04:24 PM
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!"
0