Need help for formula error

General Excel Questions & Answers

Last Post by Lionel Baijot 3 years ago

2 Posts

2 Users

0 Reactions

32 Views

RSS

Rajan Bakolia

(@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

Rajan