Programming

Programming questions? Ask a programmer for answers ASAP

Connect one-on-one with {0} who will answer your question

Customer Question

i need help i am trying...

i need help

i am trying to format a cell that will choose a cell with a number other than 0.

example A1 100

B1 0

C1 needs to pick the information from A1 since its a number other than 0

how do i format it?

i am trying to format a cell that will choose a cell with a number other than 0.

example A1 100

B1 0

C1 needs to pick the information from A1 since its a number other than 0

how do i format it?

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a programmerLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Programming Questions

I need to add three cells and if the answer is more than a

I need to add three cells and if the answer is more than a number (38) I need 0 as the result or if it is over 38 I need the balance as the result… read more

Looking for a custom formula for excel 2010. It is base on

Looking for a custom formula for excel 2010. It is base on dates, with the end product coloring a cell. I will try to describe what I'm looking for. FORUMULA REQUEST: If cell C1 (date, example 8/15/12… read more

Please how to roundup decimal places in excel complex funcitons

Please how to roundup decimal places in excel complex funcitons like imsum, imsub, imdiv or alike, thanks… read more

I am trying to create a formula that states: Cell F1 = if cell

I am trying to create a formula that states: Cell F1 = if cell A1 or B1 or C1 are blank then Cell F1 will be a "No" if true and a "Yes" if false.… read more

I need help developing a formula that will calculate the elapsed

I need help developing a formula that will calculate the elapsed hours between two dates and times while not including in the elapsed total the hours between 23:00 and 07:00. Examples….. 10/1/2011 07:… read more

Hello, I am trying to use the concatenate formula to combine

Hello, I am trying to use the concatenate formula to combine the example below: A1 = M and B1 = 07299. C1= M07299. However the problem in the leading zero is getting dropped. I have tried the usual st… read more

I have a formula based on a numeric entry into a cell (A1)that

I have a formula based on a numeric entry into a cell (A1)that then caluclates an over/under (C1) based on a number in another cell.(B1) I dont want the over under (C1)to calculate UNTIL I place the n… read more

Hi,__Im trying to do something like below___If a1 -100 and

Hi,__I'm trying to do something like below___If a1= -100 and b1 = -500 then i would like the cell c1= =-(B1-A1) = 400_If a1= -100 and b1 = 500 then i would like the cell c1= =-(B1-A1) = -600_If a1= 10… read more

i want to create with cells the following condition eg. cell

i want to create with cells the following condition eg. cell A1 if the cell value is between a certain numeric value and the b1 cell is equal to a sintax value for instance = "F#, the result at cell c… read more

I have an Excel spread sheet with my clients. I need to merge

I have an Excel spread sheet with my clients. I need to merge data from 4 cells into one cell. street address, city, state, zip / all of the info is in there but I would like it into one cell. I am te… read more

Hello, I need a formula that allows me to add to or subtract

Hello, I need a formula that allows me to add to or subtract from a given number, depending on whether I input a positive number or a negative number, ie: 100 6 106 100-6 94… read more

Hi - I need a formula for a cell (total %) that sums 2 other

Hi - I need a formula for a cell (total %) that sum's 2 other cells (% cells), as long as the sum is less than 100%. Thank you.… read more

I want to write an excel program that will execute the following

I want to write an excel program that will execute the following equation: x=1000000+.1(x) my actual equation has multiple constants and multiple percentages of x, but I can't get this simply version … read more

I need help for Excel spreadsheet formula. I want to create

I need help for Excel spreadsheet formula. I want to create the following: If A1 has Y then write T; if B1 has Y then write C; if C1 has Y then write 1, if C1 has N then write 0; write D1 ; write E1 f… read more

what is the syntax for this if function If the total in A1,

what is the syntax for this if function? If the total in A1, B1, C1 is more than 10 the sum result will appear in black colour, but if the total os A1, B1, C1 is less than 10 the sum will be shown in … read more

in microsoft excel how can I create a formula that can idenify

in microsoft excel how can I create a formula that can idenify a 5% change in value of the previous cell and make the current input value a red number if it's a 5% or more decline and a green number i… read more

How do you keep a cell ref. from changing when you insert a

How do you keep a cell ref. from changing when you insert a new row or columns. This a sample of a formula in cell D1 =A1+(B1*C1). Now when copy and paste this formula in next Row the formula in D2=A2… read more

Does excel have a if-then formula I want to enter data into

Does excel have a if-then formula? I want to enter data into a cell and if it meets certain criteria then put that information into a different cell of go to a certain cell!… read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

New York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

< Previous | Next >

LogicPro

Computer Software Engineer

9,436 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

The-PC-Guy

Software Engineer

932 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

Rafael Martins

Computer Software Engineer

449 satisfied customers

Desktop, Mobile and Web Developer. 10+ years of experience. Creative solutions provider.

Ramesh Patil

Computer Software Engineer

406 satisfied customers

MCA, 3+ years of experience in Asp.Net, C#, SSIS, VB.Net, Ms-SqlServer2005, MySql, Javascript,

Arty

Computer Software Engineer

377 satisfied customers

15+ years of programming, C, C++, Java, PHP, awk, ruby, shell, ASM, Forth, Raptor, M.A.R.I.E, Excel

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.