Thread: IF question
View Single Post
  #1  
Old August 28th, 2008, 02:35 PM posted to microsoft.public.excel.worksheet.functions
Stuart
external usenet poster
 
Posts: 157
Default 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.