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,"$YYYYMMDD$"),"")$&$""$&IF$($B$5>0,$TEXT$($B$5,"$HHMM$"),"")$&$""$&IF$($B$6>0,$VLOOKUP$($B$6,$Employees!A$2$:B$6,2)$If the result of the test is false, then return a blank.