in excel 2000 IF function using "E" does not calculate properly IF(C2=("E"),($O2),($O2))))))

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your Microsoft Excel question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your Microsoft Excel question answered.

Get An Answer

3. Get An Answer

Connect with your Microsoft Excel tech via online chat or telephone call.

Answer

Customer

in excel 2000 IF function using "E" does not calculate properly IF(C2=("E"),($O2),($O2))))))

Last updated
Tarun G
Microsoft Excel Tech

Thanks for contacting us on Experthelp. My name is Tarun and I will be happy to assist you. 

Based on your query below, I have checked the excel formula and would like to share my views on it.

1. You do not need to enclose "E" in a bracket and enclosing it in double quotes " " should do the trick.

2. Since if condition check the expression and gives the output based on whether the condition is true of false. In below query, since you are using O2 in both true as well as false condition and it will not make any difference and will always return the value from cell O2.

Please refer the simplified version of the formula. IF(C2="E",$O2,"-") - It will check if cell C2 contains E then it will give the value of cell O2 and if the condition is false, it will give hyphen "-" as an output.

I hope this will resolve your query. 

Should you need any further assistance or clarification, please feel free to let me know.

Thank you, 

Tarun G CFA

Last updated
Customer

Hello Tarun, I tried your formula, but got the same answer as I had originally, with the exception of "-".  The reason that I had the same ref. for true and false is  because the "E" substitutes for zero and means EVEN. If the cell is contains E then there is no change in value and thus would want to enter the existing amount which is located in cell O2. 

I mentioned that I'm using Exel 2000, but I'm not sure if that is the reason for the formula not working.

This formula is just part of a longer formula.  All work just fine except for the "E". All the rest are numbers from 1 to 14 and 1-14 in negative numbers.

I await to hear from you.   Bill Swan

Posted
Tarun G
Microsoft Excel Tech

Thanks Bill for your response.

In Excel 2000, there used to be a limit of 256 characters. However, in order to serve you, would you be able to share the spreadsheet along with the formula or if possible, kindly share the complete formula. In case, something is missing then I will correct the formula or if this is due to the limit of characters in a formula, then I will try to optimize it to ensure that it should display correctly at your end in Excel 2000.

Thanks,

Tarun

Posted
Customer

Hello Tarun,  I will send my spreadsheet, but need to know how to do so.  I can attach it to an email, but were do I send it?

Posted
Jenny Muralidharan
Customer Support

Hi Bill, Tarun's direct email address has been shared with you in support's response to your email (case no. 73089). We thank you for your patience while your Expert reviews your spreadsheet before providig you with the most accurate and helpful solution. 

Posted
Tarun G
Microsoft Excel Tech

Hi Bill,

For your convenience, please use my email address: C**[email protected] to share the file.

Thanks,

Tarun

Posted
Tarun G
Microsoft Excel Tech

Hi Bill, 

I believe the proposed solution has solved your issue. Please free to revert in case of any further queries.

Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Microsoft Excel Questions...

Ask Your Microsoft Excel Question & Get An Answer Now!