How to raise a value to a variable power in Form 1

[LLBP]

I'm trying to build a price calculator. I need to be able to raise a value (1.1) to the power of the value in text box [Large]. Text box [PrePrice] calculates the price based on the price table, given the selected size of product. [Large] is a number of size increments above the listed sizes (user input). For each increment we charge an additional 10%. I tried
=IIf([Large]>0,[PrePrice]*(Power(1.1,[Large])),[PrePrice])
but I get #NAME?
Thanks for any assistance.
Brent

 

[LittleSmudge]

If, what you are after is:-

Large   Result
0       PrePrice * 1
1       PrePrice * 1.1
2       Preprice * 1.21
3       PrePrice * 1.331

Is that what you are wanting ?

Then try simply

=[PrePrice]*(1.1^([Large]))

'ope-that-'elps.












G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[LLBP]

Thank you much. I actually tried that symbol but didn't inclose [Large] in parenthesis.

Thanks again,
Brent