if formula and multiple rules

HI,

hoping this is an easy one to correct, but can't think of it. below is the current formula I am using.

=IF(raw!AD2="Not a commission payable product","",raw!T2)

what I want to do is if the , raw!T2 field at end of formula is $0.00 in original cell, then I want it to be blank, if not to populate the figure.

Thanks for the help in advance.

Welcome to the forum
Try the following.

Formula:

Please Login or Register  to view this content.

Let us know how you get on.

worked perfectly thankyou. I am sure I will be back often as trying to increase my excel formula knowledge