I want to include 2 formula's in one cell but am not sure how to combine them or if it will work.
I have one column in which the user with select Y or N. If they select no I want the next cell to automatically change to "NA" - shown by this formula =IF(G9="N","NA","").
However, if the user selects Y I want the next cell to then change to a date which is calculated through other cells on the sheet in this formula +WORKDAY(B10,$B$5).
How can I make these work in unison?
I have one column in which the user with select Y or N. If they select no I want the next cell to automatically change to "NA" - shown by this formula =IF(G9="N","NA","").
However, if the user selects Y I want the next cell to then change to a date which is calculated through other cells on the sheet in this formula +WORKDAY(B10,$B$5).
How can I make these work in unison?