You've entered too many arguments for this function

[sutharnehal]

=IF(I3>O3,IF(I3>P3,IF(I3>Q3,IF(I3>R3,IF(I3>S3,"above 40ema","above 30ema","above 20ema","above 10ema"),"above 5ema",IF(I3<O3,IF(I3<P3,IF(I3<Q3,IF(I3<R3,IF(I3<S3,"below 40ema","below 30ema","below 20ema"),"below 5ema"),"No Signal"))))

Please HELP!!!!!!

[dogberry]

Hi

Can you post a sample worksheet so we can see the layout etc dont post confidental information
it will also get you a much better response.


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[sutharnehal]

Please help me to complete formula in column U to include comparison of columns R & S. Thanks!

[Andrew-R]

Each IF statement has 3 elements; the condition, the value to return if the condition is true and the value to return if the condition is false.

In your statement the highlighted IF functions exceed this number of elements:

=IF(I3>O3,IF(I3>P3,IF(I3>Q3,IF(I3>R3,IF(I3>S3,"above 40ema","above 30ema","above 20ema","above 10ema"),"above 5ema",IF(I3<O3,IF(I3<P3,IF(I3<Q3,IF(I3<R3,IF(I3<S3,"below 40ema","below 30ema","below 20ema"),"below 5ema"),"No Signal"))))

And the rest of the IF statements seem badly formed. I'd suggest your brackets need sorting out, or you tell us what you're trying to do.

[Andrew-R]

Are you trying to get a single answer which says whether the value in column I is above or below that of each column in O:S?

[bebo021999]

Try this:

Please Login or Register  to view this content.

Hope this help

[bebo021999]

I try to discover your thinking, and hope below formula can miss your target:

Please Login or Register  to view this content.

Finish with Ctrl-Shift-Enter

[sutharnehal]

Yes, it worked very well now. Thanks all for your help on this. I really appreciate help here.

[sutharnehal]

On the same file, can any one help me to develop a formula where it compares price of column I with prices of columns O,P,Q,R & S and in case if price is higher than all, it should say that "above all EMA" and in case if price is not higher than any column price, it should give message accordingly. For example, if price is not higher than column O & P, it should say that "above 20EMA". Please help me to develop such formula on above attached sheet. Thanks in advance for the help.

[bebo021999]

On the same file, can any one help me to develop a formula where it compares price of column I with prices of columns O,P,Q,R & S and in case if price is higher than all, it should say that "above all EMA" and in case if price is not higher than any column price, it should give message accordingly. For example, if price is not higher than column O & P, it should say that "above 20EMA". Please help me to develop such formula on above attached sheet. Thanks in advance for the help.

I think my formula in #7 can do.