Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Function Help, Please:)
I need the IF function to add up two cells and if the sum is greater than or equal to 80, then the cell needs to read "80," if the sum is less than 80 I just want it to show whatever number it calculates (79 and below). This is for a timesheet with overtime. Thank you for your help!! |
#2
|
|||
|
|||
Use: =IF(Cell1+Cell2<=80,Cell1+Cell2,80)
The syntax: =IF(some result equals or is less than 80, TRUE: the result, FALSE: show 80) "Pepper233" wrote: I need the IF function to add up two cells and if the sum is greater than or equal to 80, then the cell needs to read "80," if the sum is less than 80 I just want it to show whatever number it calculates (79 and below). This is for a timesheet with overtime. Thank you for your help!! |
#3
|
|||
|
|||
Try something like: =MIN(SUM(A1:B1),80)
where the 2 cells are A1 and B1 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Pepper233" wrote in message ... I need the IF function to add up two cells and if the sum is greater than or equal to 80, then the cell needs to read "80," if the sum is less than 80 I just want it to show whatever number it calculates (79 and below). This is for a timesheet with overtime. Thank you for your help!! |
#4
|
|||
|
|||
That worked; however, the results are negative numbers...?
"Wolfgang" wrote: Use: =IF(Cell1+Cell2<=80,Cell1+Cell2,80) The syntax: =IF(some result equals or is less than 80, TRUE: the result, FALSE: show 80) "Pepper233" wrote: I need the IF function to add up two cells and if the sum is greater than or equal to 80, then the cell needs to read "80," if the sum is less than 80 I just want it to show whatever number it calculates (79 and below). This is for a timesheet with overtime. Thank you for your help!! |
#5
|
|||
|
|||
Never mind about the negative number thing--figured it out :) Thanks,
Wolfgang! "Wolfgang" wrote: Use: =IF(Cell1+Cell2<=80,Cell1+Cell2,80) The syntax: =IF(some result equals or is less than 80, TRUE: the result, FALSE: show 80) "Pepper233" wrote: I need the IF function to add up two cells and if the sum is greater than or equal to 80, then the cell needs to read "80," if the sum is less than 80 I just want it to show whatever number it calculates (79 and below). This is for a timesheet with overtime. Thank you for your help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |