Simple IF statement? (1 Viewer)

[michaeljohannes]

Hello Excelers,

I'm not too familiar with Excel formulas so I apologize if this is a very mundane and simple question.

Can anyone help me do the following?

I would like to have a column calculate a total if the column before it is above 40. For example, this is a simple spreadsheet to calculate and control an overtime wage. So, IF column A is less than or equal to "40", column B = "0". IF column A is greater than "40", column B = (ColumnA - 40).

I think my 'logic' is correct but my syntax (obviously not as above!) is not working. The result would look like this:

Two cells side by side (COL A, COL B)

COL A      COL B
35           0
36           0
37           0
38           0
39           0
40           0
41           1
42           2
43           3

Can anyone give me a hand?

Much appreciated!

Mike

 

[pdx_man]

=IF(A1>40,A1-40,0)

Fill this in for Col B

 

[michaeljohannes]

Thanks, PDX_Man!

Mike