k16

Need some help as my knowledge is limited and I’m struggling with syntax of my formula? This is what I have so far, Formula in K18: =IF(K16=0,"Select nozzle colour",IF(K17=0,"Select # passes",IF(AND(OR(K16="Red",K16="Blue"),"Select correct...

Hi all, I am looking o use the traffic light system to show any dates in a cell the exceed the current date by 1day, 2 days and 3 days, but if no date just remain blank Starting in K16 thru K512 I was trying =WEEKDAY(TODAY(),1)>1 but cannot seem to get this working correctly Thanks for any help

I need help creating a formula that would look at cells to see if there is a date. If there is it should take the $ amount from another cell and then adding each time it finds a date. Example: cell K14 & K16 = 12/17/2017 cell K15 = blank cell I14 = $15,555 cell I15 = $16,200 cell I16 = $22,000...

Hi, I am trying to combine the Vlookup, Left and Right function in one cell. Column F3:F12 contain of number and G3:G12 is type and Column A is a lookup value for last four characters (A3:A14). I am apply the following formula in C3="K"&LEFT(VLOOKUP(RIGHT(--$A3,4)&"*",$F$3:$G$12,2,0),2)...