View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Accountant7 Accountant7 is offline
external usenet poster
 
Posts: 1
Default nested if statements

I have created an IF statement which I use to search a string for the letter
"a", and "a" can appear multiple times in the string. A value of "1" is
assinged each time "a" is found. I would like to know the SUM of values for
"a".

My IF statement is:
IF(ISERR(IF(SEARCH("a",$B2)0,1,0)),0,IF(SEARCH("a ",B2)0,1,0)).

I would like to include this condition in the above IF Statement.
IF B20,SUM(B2),0)