If Function error !!!
Solved/Closed
Related:
- If Function error !!!
- Network error occurred - Guide
- Cmos checksum error - Guide
- Find function on mac - Guide
- Bios rom checksum error - Guide
- Accessor function c++ - Guide
3 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
May 12, 2011 at 05:45 AM
May 12, 2011 at 05:45 AM
Hi Waseem,
Microsoft Excel's version before 2007, only 8 if commands are valid:
if you want to use use more if commands you can use micros or upgrade your Microsoft excel into 2007 or 2010.
Microsoft Excel's version before 2007, only 8 if commands are valid:
if you want to use use more if commands you can use micros or upgrade your Microsoft excel into 2007 or 2010.
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
May 16, 2011 at 10:23 PM
May 16, 2011 at 10:23 PM
Install Ms Office 2007 & Use Your Last Written Formula. It Will 101% Works.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
May 17, 2011 at 12:48 AM
May 17, 2011 at 12:48 AM
Hi Waseem,
Why don't you use Vlookup instead of Lots of If statements,
Just puts these values in a column say AD & AE :
CASH DIVIDEND $AB$4 -D2
STOCK DIVIDEND $AB$4 -D2
CFD DIVIDEND $AB$3 -D2
BOND INT $AB$5 -D2
and so on. now you can put as many as you required. (this is just an example not related to your formula)
and now put Formula in E2 as
= VLOOKUP(B2, $AD$1:$AD$100,2,false)
Why don't you use Vlookup instead of Lots of If statements,
Just puts these values in a column say AD & AE :
CASH DIVIDEND $AB$4 -D2
STOCK DIVIDEND $AB$4 -D2
CFD DIVIDEND $AB$3 -D2
BOND INT $AB$5 -D2
and so on. now you can put as many as you required. (this is just an example not related to your formula)
and now put Formula in E2 as
= VLOOKUP(B2, $AD$1:$AD$100,2,false)
May 12, 2011 at 07:20 AM
Thank you very much for reply !!!
Is it possible to add like below
8(if statements) + 8(if statements) + 8(if statements) If so please let me know the formula.
If not can you please suggest some other solution !! Like IFOR statements or someother macro as an example!!!
May 12, 2011 at 10:19 AM
Here is a strategy to use more if statements.
A1 will be the cell to look at.
Now use a random cell (I used D9) to put the following formula in:
Now use another random cell (I used E9) to put in the next formula (only created 2 IF's):
Now use another random cell (I used F9) to put in the next formula (only created 1 IF):
Now use this formula to combine the other three:
This way you can use 9 x 8 = 72 IF statements. Is that enough :) ?
Best regards,
Trowa
May 14, 2011 at 11:20 AM
Thanks for your explaination.
For your reference i have included the sample file in the below website.
http://www.speedyshare.com/files/28456549/tracker_template.xls
I have also mentioned my exact problem in that file.
Could you please look into it and let me know how to use more if statements in such criteria.
Thanks Again !!!
May 16, 2011 at 08:28 AM
Could someone please look into the above issue !!!
Thanks in Advance !!!
May 16, 2011 at 08:53 AM
quote
The bolded items is just 7 with 8 if statements. Which is needs to be increased by 31.
unquote
Don't understand this? How can you increase a formula by 31?
Could you write out your nested IF formula so I can break it down for you?
Currently I can only guess what your other IF statements can be. Did I miss something in your file?
Best regards,
Trowa