If formula to round down

I am using this formula in excel 2010, "=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,H7-P7)/0.25),IF(I7>P7-I7)/0.25)))" which is not being accepted and displays a message "too many arguments for this function" with only the last section 0.25 highlighted.
Values only are required to be entered in either H7 or I7 but not both. P7 is the end result of entry from either H7 or I7 with Q7 providing a breakdown of P7 result, the reason for /.025.

If I enter the formulas individually into Q7, "=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,H7-P7)/0.25))" the correct result is displayed when a value is entered into H7 & when reversed "=IF(ISBLANK(P7),"",IF(I7>0,P7-I7)/0.25))" with an entry in I7 a correct answer is given as it should, though not with the combined formula as when I join the two I cannot get it to work.
I have tried ending with; ,""))) & removing P7>0, & I7>0, also tried SUM in place of IF also without success.
What have I done incorrectly?

=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,(H7-P7)/0.25,IF(I7>0,(P7-I7)/0.25,0))))

You were missing a few , and ) and your final if had no true or false statements.

I've had to change it quite a bit, please check it does what you require!

=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,H7-P7)/0.25),IF(I7>P7-I7)/0.25)))

It is hard to know what you are trying to do, but if the 2nd if statement just after IF(P7<0, You can not assing a value to a cell, the Q7="0" is the problem.
If you post am example, it would help.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Pls Don't cross post WITHOUT to provide a link for this.

http://www.ozgrid.com/forum/showthread.php?t=175708

And if you like, pls read here why you must not do it!

http://www.excelguru.ca/content.php?...-cross-posters

7Black,

For the benefit of other users looking for a similar solution, it will be good if you edit the thread title.

Sure, thank you for editing the title.