I have a cell that I need to calculate XX value, minus XX value of another cell, but return "0" (zero) if a different cell shows $0 in it.
Example:
In cell L3, I need it to subtract value in cell L2 from value in K3, but if K3 value is 0 (as in $0), then I want L3 to show $0.
This seems so simple, but for the life of me I can't get it to work.
Thanks,
Vince
Bookmarks