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?
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?