answersLogoWhite

0


Best Answer

It uses the same general syntax as the IF function does in other spreadsheet applications. It has 3 parts, a condition to test, what to do if the condition is true and what to do if it is false.

IF( Condition, True action, False action )

For example, to test cell A3 and if its value is over 100 or not, you could do this:

=IF( A3>100, "Value is over 100", "Value is 100 or less")

User Avatar

Wiki User

8y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you properly write the IF THEN syntax using Numbers on a MacAir?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Using a variety of sentence as to structure?

syntax


Write a sample program using ASPNET explaining all the syntax and semantics of the program?

write a sample program using asp.net explaining all the syntax and semantics of the program


Syntax when using image tag to an HTML document?

The basic syntax is:Additional optional attributes include height, width, and border.


Does English syntax allow infinitely long sentences?

No. However it is possible to construct very long and complex sentences using correct syntax.


How do you find the circumference using pie?

The correct syntax would be 'pi'.


How do you write a javascript to swap two numbers without using third one?

By using the algorithm of bitwise EORing (Exclusive ORing) the numbers together:If the two numbers are X and Y, then to swap them:X = X EOR YY = Y EOR XX =X EOR Ywill swap them.With knowledge of that algorithm, one then uses the syntax of Javascript to implement it.


What is the spreadsheet formula to calculate the difference between two numbers?

It depends which spreadsheet package you're using, and how its syntax is set but - something like... D3=A3-B3 or D3=sum(A3-B3)


Benefits of using HTML?

The main benefit of using HTML is its easy syntax. The tags are very powerful to use.


What are the basic syntax of c program?

You have to be more specific. What part of C syntax? Do you want the syntax for outputing a number or sentence, do you want to syntax for creating a array, struct, a user defined function or what? #include iostream using namespace std; int main { cout << "Hello World!" << endl; return 0; };


What is the Roman culture for the Roman china?

Please rephrase the question using English syntax.


How do you set the date on a Raspberry Pi?

You can set it by using the "date" command Syntax is "date MMDDhhmmYY"


Sum some in one sentence?

Here are some ways to work out the sum using algebra.