Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
307
Views
Topic starter
As you will see in attached picture, some of the data is blank in SELLING PRICE. Thats why NET PROFIT is showing entire value of PURCHASE PRICE as a negative value and the PROFIT % is showing an odd error.
Is there an option or formula that commands the applied formula to leave a blank or space if there no value in SELLING PRICE and proceed to next value without any error.
Thanks
Rajan
Posted : 03/03/2022 3:27 pm
Hi Rajan,
Here is a suggestion in the attached file.
BR,
Lionel
Posted : 04/03/2022 1:49 am
