New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

Start a Discussion

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

HELP!! iWork Numbers formulas

Post Reply New Thread Subscribe

Thread Tools

Member Since: Nov 30, 2009
Posts: 5
MazdaspeedK is on a distinguished road
Mac Specs: Macbook Pro 13"

MazdaspeedK is offline
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.

QUOTE Thanks

Post Reply New Thread Subscribe

« iphoto freezing when zooming in on pic | Mail to Groups »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Starter
Last Post
iWork 09 Numbers - tables question Spook OS X - Apps and Games 2 05-06-2009 03:04 PM
New to IWork 09 and Numbers axis42 OS X - Apps and Games 1 03-19-2009 04:30 AM
iWork Numbers - how to count with time jakudo OS X - Apps and Games 5 02-02-2009 12:57 PM
iWork 08 - Numbers Question mac57 OS X - Apps and Games 0 09-30-2008 10:02 PM
Combine Grapher with iWork Numbers? klauscdn OS X - Apps and Games 0 06-11-2008 11:26 AM

All times are GMT -4. The time now is 05:26 AM.

Powered by vBulletin
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

Welcome to

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!

(4 digit year)

Already a member?