Forum

Notifications
Clear all

Need help for formula error

2 Posts
2 Users
0 Reactions
176 Views
(@rjrocks)
Posts: 1
New Member
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

RajanScreenshot-2022-03-03-001311.png

 
Posted : 03/03/2022 3:27 pm
(@questvba)
Posts: 125
Estimable Member
 

Hi Rajan,

Here is a suggestion in the attached file.

BR,

Lionel

 
Posted : 04/03/2022 1:49 am
Share: