Custom Formula using VBA

Hi,

I have the following formula which I want to be able to use as a custom function i.e. =SWITCH(Cell1,Cell2,"Profit","(Loss)").

=IF(AND(F23<0,H23<0),"(Loss)",IF(AND(F23>=0,H23>=0),"Profit",IF(AND(F23<0,H23>=0),"(Loss)/profit","Profit/(loss)")))

Is this possible at all?

Regards

Colin

Hi Colin,

Try this:

Please Login or Register  to view this content.

Regards,
Rick

Where do I put the code - This workbook or Sheet1?

Also do I use it as follows:

=SWITCH(A1,A2,"Profit","(Loss)")

Got it - brilliant work - thanks!