How to write this nested if

[peakoverload]

I have a workbook where Column C denotes the type of rate a client should pay on. Column E shows the hours they should be charged on and Column F the minutes.

If C1=1 it means the client pays for rounded up hours so if E1=9 and F1=10, they pay for 10hrs (The client used 9hrs 10Mins but as its over 9hrs it gets rounded up to 10hrs)
If C1=2 it means the client pays for rounded up 1/4hrs so if E1=9 and F1=10 they pay for 37 quarter hrs (9x4=36 quarter hours but the client used an additional 10 minutes which is rounded up to a quarter hr equaling 37. If they had used 18 minutes this would get rounded up to 38 quarter hours and equally if they used 35 minutes it would get rounded up to 39 quarter hours)
If C1=3 it means the client pays by the minute so if E1=9 and F1=10 they pay 550mins (9x60+10)

I can't work out how to write this as one nested IF statement, I've always struggled to get the right syntax and keep getting very odd results. Can anyone point me in the right direction?

[6StringJazzer]

I tried this on your examples and it worked:

Please Login or Register  to view this content.

[modytrane]

Using the following formula:

You'll get these results:
C1 E1 F1 G1
1 9 10 10
2 9 10 9.25
3 9 10 9.166666667

[modytrane]

The results in my response are in hrs.

[peakoverload]

I tried this on your examples and it worked:

Please Login or Register  to view this content.

That's perfect! Works like a charm. I've never used CEILING before or CHOOSE, very handy functions will have to remember them for the future.

Many Thanks for the help.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.