if-statement inside an if-statement

If A1 shows 10:00am and A2 shows 4:00pm, then A3 calculates the total number of hours:

=(A2-A1)*24


But if A1 shows "Off," then A3 shows 0:

=IF(A1="Off",0,(A2-A1)*24)


Now, if I want to change "(A2-A1)*24" to another if-statement, how do I do this? I can always set up a hidden cell (A4) that contains the results of the first if-statement, and then say:

=IF(A1="Off",0,A4)

But can I do this without going through all the trouble of setting up hidden cells?

Any ideas?

Hi,

How about

=IF(A1="Off",A4,(A2-A1)*24)

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions Forum