Excel Question: print the current time in Excel Cell?

 

Select a cell and hold the CONTROL + SHIFT keys and press colon to insert time.

Use CONTROL + semicolon to insert the date.
--------------------

(If you use the =now() formula in a cell, the present date and time will be inserted - but it will update to the present date/time every time the sheet is recalculated.)

the IF Excel Function

Nesting the AND function inside the IF function

=IF(AND(B1>100,B2>100,B3>100),”Over Budget”,”Acceptable”)
 

Check whether some number exist in the column ... T? F?

Check whether some number exist in the column ... T? F?

A1 = 5
A2 = 3
A3 = 1

Check for number 7 answer False
Check for number 1 answer True

Icing on the cake .... how many times does it exist?

6 hours ago

by garbo744...

Member since: May 27, 2008

 

Best Answer - Chosen by Asker

To check if the numbers 7 or 1 appear in A1:A50:

=IF(COUNTIF(A1:A50,7)>0, "True", "False")
=IF(COUNTIF(A1:A50,1)>0, "True", "False")

Otherwise, just to count the occurrences:

=COUNTIF(A1:A50,7)
=COUNTIF(A1:A50,1)

 

Excel Ceiling Roundup Functions

Excel Question: What IF Function to use Cell A1 1 to 10 Value 1, 11-20 value 2, 21-30 value 3, ...?

31 to 40 value 4, 41 to 50 value 5.
example A1 = 05 then B1 = 1
A1 = 11 then B1 = 2
A1 = 30 then B1 = 3
A1 = 38 then B1 = 4
A1 = 46 then B1 = 5

by C Masters

Best Answer - Chosen by Asker

it would be easier to make this a mathematical function than a logical function
instead of using many IF statements to check the value, you can use a formula like this

=CEILING(A1,10)/10 or =ROUNDUP(A1/10,0)
 

Stem and Leaves Video

http://www.sophia.org/algebra-ii-lesson-on-stem-and-leaf-plots-histogram-tutorial

Videos by Business Topics

http://www.excel43.com/videos-by