iworks numbers formulae

Joined
Aug 13, 2013
Messages
1
Reaction score
0
Points
1
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?
 

Raz0rEdge

Well-known member
Staff member
Moderator
Joined
Jul 17, 2009
Messages
15,780
Reaction score
2,130
Points
113
Location
MA
Your Mac's Specs
2022 Mac Studio M1 Max, 2023 M2 MBA
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..
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top