How Do I Write This Formula....
Posted by Edders on August 23, 2001 1:17 PM
Hope someone can help. I'm trying to make a spreadsheet for my per diem costs at work. I'm doing OK (this is my first try) but can't work out a formula for my "HOURS CREDIT" line.
I need a formula that will show the MAX of say A1:B1 in C1 UNLESS the MAX is LESS THAN 4, then I need it to show 4 in C1.
I look forward to an answer and if I need post any more info let me know.
Oh, and as I have no access to internet at home, if I could get a reply via email too to edderspcs@yahoo.com I'd be very grateful.
Thanks again
Edders
Posted by Barrie Davidson on August 23, 2001 1:22 PM
Try,
=IF(MAX(A1:B1)<4,4,MAX(A1:B1))
Barrie
Posted by IML on August 23, 2001 1:23 PM
Try
=IF(MAX(A1:B1)>4,MAX(A1:B1),4)
Good luck
Posted by Mark W. on August 23, 2001 1:31 PM
=MAX(A1:B1,4)
Posted by Barrie Davidson on August 23, 2001 1:32 PM
Mark, much better solution (NT)
