Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
HELP!! iWork Numbers formulas
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MazdaspeedK" data-source="post: 1010792" data-attributes="member: 133806"><p>Hi all, need some help on iwork numbers formulas. I am making myself a eBay calculator with Numbers but can't really figure it out how. This is something I want to create:</p><p></p><p>example 1) $50.01 - $1,000.00 (my closing value will be E3)</p><p></p><p>8.00% of the initial $50.00, plus 4.50% of the remaining closing value balance ($50.01-$1,000.00)</p><p></p><p>This is what I figure out =SUM((50*8%)+(E3-50)*4.5%)</p><p>which gives me exact correct answer.</p><p></p><p></p><p>example 2) Equal to or Over $1,000.01</p><p></p><p>8.00% of the initial $50.00, plus 4.50% of the initial $50.01-$1,000.00, plus 1% of the remaining closing value balance ($1,000.01 - closing value)</p><p></p><p>What will be the formula for this? I have no clue how to type the $50.01 - $1,000.00.</p><p></p><p>PLEASE HELP!!</p></blockquote><p></p>
[QUOTE="MazdaspeedK, post: 1010792, member: 133806"] Hi all, need some help on iwork numbers formulas. I am making myself a eBay calculator with Numbers but can't really figure it out how. This is something I want to create: example 1) $50.01 - $1,000.00 (my closing value will be E3) 8.00% of the initial $50.00, plus 4.50% of the remaining closing value balance ($50.01-$1,000.00) This is what I figure out =SUM((50*8%)+(E3-50)*4.5%) which gives me exact correct answer. example 2) Equal to or Over $1,000.01 8.00% of the initial $50.00, plus 4.50% of the initial $50.01-$1,000.00, plus 1% of the remaining closing value balance ($1,000.01 - closing value) What will be the formula for this? I have no clue how to type the $50.01 - $1,000.00. PLEASE HELP!! [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
HELP!! iWork Numbers formulas
Top
