IF question

[Stuart]

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.

 

[David Biddulph]

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

 

[Stuart]

Thanks David.

How do I change it so that if C4 is empty of any data, then J4 stays blank,
please?

Regards,
Stuart.