| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Automatically inserting text into a cell
I have a formula in a cell that reads like this;
=IF(A12="","",WORKDAY,(A12,5) In column M I am asking if a report is due Y/N. Can I add to the above formula to automatically insert "N/A" into N12 if there is a "N" in column M? |
|
#2
|
|||
|
|||
|
One way:
N12: =IF(M12="N","N/A",IF(A12="","",WORKDAY(A12, 5))) In article , Roy wrote: I have a formula in a cell that reads like this; =IF(A12="","",WORKDAY,(A12,5) In column M I am asking if a report is due Y/N. Can I add to the above formula to automatically insert "N/A" into N12 if there is a "N" in column M? |
|
#3
|
|||
|
|||
|
Thanks, this worked.
"JE McGimpsey" wrote: One way: N12: =IF(M12="N","N/A",IF(A12="","",WORKDAY(A12, 5))) In article , Roy wrote: I have a formula in a cell that reads like this; =IF(A12="","",WORKDAY,(A12,5) In column M I am asking if a report is due Y/N. Can I add to the above formula to automatically insert "N/A" into N12 if there is a "N" in column M? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
