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.
Bookmarks