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.

iworks numbers formulae


Post Reply New Thread Subscribe

 
Thread Tools
alfaman1970

 
Member Since: Aug 13, 2013
Posts: 1
alfaman1970 is on a distinguished road

alfaman1970 is offline
Hi, I have a question about formulae in iworks numbers relating to the following problem.

I have 3 numerical cells, A, B and C

I want to input figures in cells A and B to give a certain return in C

The criteria I am using are as follows:

IF A>B THEN IF TRUE C=2, IF FALSE C=0
IF A=B THEN C=1 EXCEPT IF A=0 THEN C=0

Can any please help with writing a formula for this?
QUOTE Thanks
Raz0rEdge

 
Raz0rEdge's Avatar
 
Member Since: Jul 17, 2009
Location: MA
Posts: 7,699
Raz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant futureRaz0rEdge has a brilliant future
Mac Specs: 27" i7 iMac, 24" iMac, 13" Macbook Air, iPhone 5 & 5S, iPod Nano 7th Gen, iPad 2 16GB WiFi, iPad 3

Raz0rEdge is offline
Try the following formula:
Code:
=IF(A2>B2, 2, IF(A2=B2, IF(A2=0, 0, 1), 0))
I used the following values for A and B

A B C
1 2 = 0
4 3 = 2
5 5 = 1
0 0 = 0

See if that works for you..

--
Regards
...Ashwin



Be sure to read the Community Guidelines | The more information you provide, the better answers you get, remember GIGO.
QUOTE Thanks

Post Reply New Thread Subscribe


« iTunes store not working (on a mac) | Access reference tools translator from VBA in Mac Excel 2011 »
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
Thread Starter
Forum
Replies
Last Post
Absolute value in numbers '09 dhmmjoph OS X - Apps and Games 0 11-13-2012 09:13 PM
Finder won't start laurag OS X - Operating System 5 04-13-2012 06:46 PM
Phone numbers disappear in Address Book Juba22 OS X - Apps and Games 0 12-14-2009 09:48 AM
learning to use Numbers in iWorks Sai OS X - Apps and Games 4 10-24-2008 12:46 AM

All times are GMT -4. The time now is 04:48 AM.

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

Welcome to Mac-Forums.com

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?