VBA Formula

[VbaHell]

Hello all

Can you help please on this formula

=IF(ISNUMBER(FIND(Well-being,F24)),"",B24-$B$8)

I am trying to say the following

If = F24 = "Well-being" then leave cell blank, if = F24 is not equal to "Well-being" then B24-$B$8

The reason why I tried to use (ISNUMBER(FIND( is because "Well-being is part of a string of numbers and text

IE: 1: Well-being fghfhj or 5: 114A Well-being hfhfh

 

[JumboCactuar]

The cell always start with well-being?

If so you can do

=IF(LEFT(F24,10)="Well-being","",B24-$B$8)

 

[VbaHell]

Hi JumboCactuar

Thanks for the reply

THe cell will not start with Well-being and is in a string on numbers and text as per the example, this is why i did not use (Left(

 

[Fluff]

How about
=IF(ISNUMBER(SEARCH("Well-being",F24)),"",B24-$B$8)

 

[VbaHell]

That's great Fluff
Thank you

 

[Fluff]

You're welcome