Formula help

27Black

New Member
Joined
Mar 2, 2013
Messages
4
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?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
I do not understand your formula
Last if has no true nor false values? IF((I7>P7-I7)/0.25),valueiftrue, valueiffalse)
May be you have problems with parethesis
I have noticed you have missed some of them
Sergio
 
Upvote 0
I do not understand your formula
Last if has no true nor false values? IF((I7>P7-I7)/0.25),valueiftrue, valueiffalse)
May be you have problems with parethesis
I have noticed you have missed some of them
Sergio

I solved it;

=IF(ISBLANK(C4),"",IF(A4>0,(A4-C4)/0.25,IF(B4>0,((C4-B4)/0.25),"")))

it works. TY.
 
Upvote 0

Forum statistics

Threads
1,216,798
Messages
6,132,755
Members
449,759
Latest member
exnoob

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top