Formula Help

Brandy S. PVD

Below is a screenshot of the sheet that I am trying to create a formula on. 

What we need is a formula that will calculate the Quantity x Unit Price + Extra Charges = Total Price. BUT we only need this calculation if Fixed Quote $ is blank. If Fixed Quote $ IS populated then we need that value to populate in Total Price. 

Any help would be greatly appreciated.

Thank you,

Brandy

Andrew DeCounter

Brandy,

I'd recommend using IF in conjunction with ISBLANK() here. Try giving it a shot with the new in app formula help.

 

A quick example might be:

IF(ISBLANK([Fixed Quote $]6),[Quantity]6*[Unit Price]6+[Extra Charges]6,[Total Price]6)

steven.reed14881

Brandy,

Here is another solution to try to achieve the same thing: 

=IF([Fixed Quote $]2 = 0, (Quantity2 * [Unit Price]2) + [Extra Charges]2, [Fixed Quote $]2).

Whatever works best for you.

Brandy S. PVD

This worked perfectly, thank you!

We also added a +[Extra Charges] to the end to include those in our final number with the Fixed Quote.

Thanks for the help.

Brandy