0
How do you enter the IF function to display the message Significant for any percent greater than 20 percent Otherwise display the message ok in Excel 2007?
Wiki User
∙ 11y ago
Say the value is in B3, then the formula would be:
=IF(B3>20%,"Significant","ok")
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is the if function for cell c3 that assigns the value of cell d5 to cell c3 if the value in cell f2 is greater than the value in cell f3 otherwise the if function assigns 0 to cell c3?
=IF(F2>F3,D5,0)
Design a function named max that accepts two integer values as arguments and returns the value that is greater of the two For example if 7 and 12 are passed as arguments to the function the function?
The function already exists in PHP and is even called max(); Otherwise use: function max ($one, $two) { return $one > $two ? $one : $two; }
How does an exponential function differ from a power function graphically?
An exponential function of the form a^x eventually becomes greater than the similar power function x^a where a is some constant greater than 1.
Is y greater than x 2 a function?
no, but y = x2 is a function
Which is greater 0.47 or 0.08?
0.47 is greater because its most significant digit is in the tenths place.
Is sine greater than one?
No angle has a sine function greater than 1.
How is precision related to the significant figures in a measured quantity?
The greater the number of significant figures, the greater the precision. Each significant figure increases the precision by a factor of ten. For example pi = 3.14 is accurate to 3 significant figures, while pi = 3.14159 with 6 significant figures is a more accurate representation.
How do you add a 4 digit and a 3 digit number?
Add the least significant digits (carry any thing greater than the base)Add the carry and the next least most significant digits, (carry anything greater than the base)Add the third most significant digits, (carry anything greater than the base)Add the carry to the most significant digit.Done
What is significant about the density of water?
Probably the most significant thing about it from a biological standpoint is that it's greater than that of ice.
Is 1.9 greater than 0.95?
Yes, the most significant digit is the ones, and 1 is greater than 0.
Is 3.05 greater or is 3.9 greater?
Depends, do they have a negative sign in front? if so then -3.05 > -3.9 otherwise 3.9 > 3.05
Which is greater 065 or 0006?
Where is the decimal point??? Otherwise as written 65 > 6
