[Blocked Image: https://www.ozgrid.com/forum/core/images/avatars/fb/135-fb73481a355c95eb61e7e0e33e97f7ea9e01dab0.jpeg]
Hello,
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
Carim
[Blocked Image: https://www.ozgrid.com/forum/core/images/avatars/fb/135-fb73481a355c95eb61e7e0e33e97f7ea9e01dab0.jpeg]
Carim
Hello,
Best is to post directly in Forum ...
You can test : =IF(D1="Approved";B1;IF(D1="Sold";0;"-"))
Hope this will help
MSRaza
Thanks it is working. You are great