'If' formulas

[Jannae72]

Morning all,

I have a document in excel with two formulas that I need to create a similar formula in livecycle designer.

Highlighted in red)     =IF($B$6="",B7+C7+D7+E7+F7,B7*$B$6+C7*$C$6+D7*$D$6+F7*$F$6+E7*$E$6)

highlighted in blue)     =SUM(G7:G9)/$H$3

I have attached the excel spreadsheet along with the Livecycle designer to assist.

If anyone can be of assistance it would be greatly appreciated.

Jen

[Paul_Butenko]

Hi,

I made this script for you.

See attachment.

BR,

Paul Butenko

[Jannae72]

That is excellent Paul.  Thank you so much for your prompt answer. 

Jen