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