INUMBER returning a value in another cell

Hello,

im trying to get this to work =IF(ISNUMBER(SEARCH(F18;G18)); "=B2"; "0")

So if F18 and G18 cells match, i want it to return the number in cell B2, or else a zero.

Regards
Dexel

Thank you, both of them work.

Except that i cant use "," but have to use ";" instead. Dont know why.

//Dexel

Originally Posted by Dexel

Except that i cant use "," but have to use ";" instead. Dont know why.//Dexel

That's because of your regional settings. Countries which use full stops for decimals (12.34) (like the UK and USA) use commas in formulae. Countries which use commas to separate decimal numbers (12,34) (like Sweden) have to use semi-colons in formulae instead, so that Excel doesn't get confused between decimal separators and formula separators.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.