I am checking a percent in cell AF50 and wanted the false statement to show in red but not sure how to? Here is the syntax: =IF(AF50<=0.02,"Conformance to specifications Listed","Nonconformance")...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have a source file that I use to insert data/text into row 2 and then always insert a new row above, so the preexisting info then goes to row 3. I did this so the formulas in destination file wo...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I'm using the function =IF(V24<=AH19,"Conformance to specifications Listed","Nonconformance") but if the cell AH19 does not have a value in it or "N/A" in it I need it to return nothing (blank) in...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am starting to make a search engine and not sure which way to go about doing this. Theres probably a ton of ways but would like to find the best way. What I have is a list of "materials" in col...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have a column with dates formatted as, 1/10/2008, etc and each date is different. If I had these dates in one column I would like the adjacent column to automatically display a date exactly 90 d...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/10/2008 Rating: 7.8 Views: 11
Is it possible to have a custom format set up with symbols such as Sigma, the symbol for standard deviation... in excel? Cant find how to insert special characters like this
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
When typing in the formula =Confidence(0.5,"standard deviation",sample size). What if my sample size may be changing from 5 to 10? How can I auto input what is used since the sample size chang...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
have worksheet with time in and time out. used formula (IF(ISERROR(DAY(M1-O1)&":"&TEXT(M1-O1,"hh:mm")),"Data Entry Error",(DAY(M1-O1)&":"&TEXT(M1-O1,"hh:mm"))) to find difference. NOW need to ta...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/24/2008 Rating: 8.4 Views: 0
Hello,
Does anyone experience any cpu processing constraint from excel? Could someone in the know show me how to make excel program run on a quad-core pc more efficiently? Presently, my excel ha...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hello experts,
Hope you are all well. :)
I have data in the attachment and would like to try and do the following:
1) If leg = FX, delete that row
2) If purchtr_i of Futures leg - purchtr...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 03/31/2008 Rating: 9.2 Views: 0
