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 I'd be very grateful.

Thanks again


Posted by Barrie Davidson on August 23, 2001 1:22 PM



Posted by IML on August 23, 2001 1:23 PM


Good luck

Posted by Mark W. on August 23, 2001 1:31 PM


Posted by Barrie Davidson on August 23, 2001 1:32 PM

Mark, much better solution (NT)