=IF(ISNUMBER(C4),ROUND(C4*J4,2),IF(C4="item",1,IF( C4="","","undefined
output")))
--
David Biddulph

"Stuart" wrote in message
...
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.