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.

IF question
 

=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.

IF question
 

Thanks David.

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

Regards,
Stuart.

IF question
 

=IF(C4="","","whatever you want J4 to be in the cases where C4 isn't blank")
--
David Biddulph

"Stuart" wrote in message
...
Thanks David.

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

Regards,
Stuart.