Function If Else needs to cater for zero value

[nigelog]

This function works perfectly to search for a string - if found in a range sum the two values and calculate a percentage contribution to the total

However it takes the Else statement of equal to 1 when I want to enter "0" if the revenue value is equal to zero

I tried the below but it does not replace the 1 with a zero

Any help appreciated

Please Login or Register  to view this content.

[daboho]

Please Login or Register  to view this content.