Add a formula to cell B$7$ that creates an Invoice Number from the date, the time, and the ID number on the Employees worksheet for the employee listed in cell B$6.$ The formula will include an IF function, the TEXT function, and a VLOOKUP function.

The logical test is testing if cell B$4$ is greater than $0.$

If the result of the test is true, then TEXT$($B$4,"$MYYMMDD$"),"$nI $18"$

$"$&$1$F$($B$5>0,$TEXT$($B$5,"$HHMM$"),")$ &$""$&IF $($B$6>0,$VLOOKUP$($B$6,$EmployeesIA$2$:B$6,2)$

If the result of the test is false, then retum a blank.

$\backslash$table$[[3],[4],[5],[6],[7],[9]]$