Create the necessary Excel expression to solve the following:
Sales tax is calculated on sales when the sales are greater than $1.00 and when the product code does not start with the letter N. It is rounded up to 2 decimal places.
Assume a 4 character the product code (like N500 or B201) is in cell A5, A6 etc. The quantity sold in is given in cell B5, B6, etc the unit cost in cell C5, C6, etc and the sales values in cell D5, D6 etc and the calculated sales tax value in cell D5, D6 etc, with the sales tax percent constant found in cell X50.
You will want to create a formula for the sales tax in cell D5 that can be copied down for the required number of rows that match the entries in the table.