Don’t have an account yet? Register yourself now and be a part of our community!
[Blocked Image: https://www.ozgrid.com/forum/core/images/avatars/fb/135-fb73481a355c95eb61e7e0e33e97f7ea9e01dab0.jpeg]
Best is to post directly in Forum ...
You can test : =IF(D1="Approved";B1;IF(D1="Sold";0;"-"))
Hope this will help
Thanks it is working. You are great