Hello
G5 contains a code - could be anything but if there is a K in that code then I want, cell C19 to run a formula: value in G6 divided by 12 multiply by -1 to give a negative figure. But if there's a K in G5 then I want just G6 divided by 12.
What I have at the moment is:
=IF(G5="*K*",G6/12*1,G6/12*-1)
I've had a look round and there is ISERROR, SEARCH etc which will return True and False, but I want a math result. The asterisk for wildcard isn't working for me.
Can you tell me where I've gone wrong?
thank you for helping
____________
Pendle
G5 contains a code - could be anything but if there is a K in that code then I want, cell C19 to run a formula: value in G6 divided by 12 multiply by -1 to give a negative figure. But if there's a K in G5 then I want just G6 divided by 12.
What I have at the moment is:
=IF(G5="*K*",G6/12*1,G6/12*-1)
I've had a look round and there is ISERROR, SEARCH etc which will return True and False, but I want a math result. The asterisk for wildcard isn't working for me.
Can you tell me where I've gone wrong?
thank you for helping
____________
Pendle