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!! |
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!! |
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!! |
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!! |
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!! |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com