First posting and new to excel formulas and functions.
Want a formula that determines if a text in a cell reads (exact($c5,"Delivered") otherwise delete "" and if not, keep text in cell the same.
Need assistance finishing this formula if this is possible. =IF(exact($c1,"Delivered"),"",xxxxxx) where xxxxxx reads the text already in the cell.
Text in cell now:
C1 = Delivered
C2 = Not Delivered
C3 = Not Delivered
C4 = Delivered
This is what I want to display:
C1 =
C2 = Not Delivered
C3 = Not Delivered
C4 =
Again new to excel formula and can't seem to figure this last part out even after search internet.
thanks
Bookmarks