IF Formula.
Hello
Please could someone assist
C1 and D2 are linked cells
if
C1 has a value, and D1 doesnt, then my formula in C2 should read C1 & " x Cases"
If
D1 has a value and C1 doesnt, then my formula in c2 should read D1 & "x Spilts"
now here is where im stuck
if C1 has a value and D1 has a value, then my formula in C2 should read, C1 & " x Cases" & D1 & " x Spilts"
if C1 has no value, and D1 has no value, then blank
thanks in advance
Bookmarks