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 firstname.lastname@example.org I'd be very grateful.