Hi,
In cell C17 enter the formula as follow

=if((C13+C15)<6,"N/A","REQUIRED")
If this was helpful please say yes, thanks

"Codeman" wrote:

I need help with the following;

I want to add cells C13 + C15 and their sum to be in C17.
However, C17s sum should show N/A until the sum is 6 or more at which time
the display in C17 should read REQUIRED and not a number.

Can this be done? If so what would be the formula?

Thanks in advance for your help.