View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default A number autofill !!

How would I exclude NH as zero and not show as 1?

In C2, copied down:
=IF(B2="","",IF(B2="NH",0,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Feb 5, 11:01 am, "pano" wrote:
After having another look at this I need the formula to allow a
product NH not to count as 1.
How would I exclude NH as zero and not show as 1????