MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)