IF question
Hi,
Can someone help with the following conditional IF question please:
If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2
places
or if C4 is the text "item" or "Item", then take the value to be 1.
If C4 is empty, do nothing.
Regards and thanks,
Stuart.
|