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
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.
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.
Related:
- Simple but difficult-to-find formatting solution
- Simple diagram of hard disk - Guide
- Driverpack solution download - Download - Cleaning and optimization
- Floppy disk fail 40 solution - Guide
- Simple tv windows - Download - IPTV players
- How to clear formatting in excel - Guide
1 response
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!"
=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!"
