ExcelBanter - Automatically inserting text into a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Automatically inserting text into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/31100-automatically-inserting-text-into-cell.html)

Roy

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?

JE McGimpsey

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?

Roy

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?

All times are GMT +1. The time now is 07:05 PM.