Excel Function (need a Like function)

[jackjack]

Well I'm working on something and need a bit of help, I'm used to using SQL commands, and this is what I need:

=IF(B163 like '%+1%', N163, (BH162+(N163-N162)))

If B163 contains +1 then it should return N163, if not it should return (BH162+(N163-N162))

Obviously no like function, so I need some way of accomplishing the same thing. All help is greatly appreciated. Thanks,

jackjack

[daddylonglegs]

Does this work?

=IF(B163="+1",N163,BH162+N163-N162)

[rylo]

Hi

If you are trying to do this with functions, then have a look at SEARCH and FIND functions.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

These will bring back an error if it is not found, otherwise the position in the string being searched. So you could do something like

Please Login or Register  to view this content.

rylo

[jackjack]

Sorry should have specified, daddylonglegs +1 is only part of the value, got text and contains +1 in it.

rylo it's saying Err: 508, not quite sure why it's not working, it looks alright.

[jackjack]

Ok should say I'm using openoffice.org's calc, basically an excel clone. Anyways, I'm trying to use this:

Please Login or Register  to view this content.

And it's returning: Err:508

[rylo]

Hi

Don't know anything about the appn you are using so this would only be a guess. The ISERROR function returns a boolean result so either remove the =1 part of the test or change 1 to TRUE and see how that goes....

rylo