Search results
Results from the WOW.Com Content Network
I am in need of an IF Function that will check the first three characters in Column B and Set a Text Value in Column A for that row Example: If Cell B1 = P42ABC123N, Then cell A1 is set to "F32" IF B1 Begins with P21, Set A1 to F21 or, If B1 Begins with P24, Set A1 to F24 or, If B1 Begins with P28, Set A1 to F28 or,
Re: If then function for an interval To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be ...
Join Date 03-23-2004 Location London, England MS-Off Ver Excel 2019 Posts 7,068
Join Date 06-22-2004 Location Surrey, England MS-Off Ver Excel 2013 Posts 4,967
Hi, I have a general question for the If statement. I guess it is answered somewhere else already but I could not find anything (its quite hard to describe it) I use it very often like this: If(A3+B5 > 20, A3+B5,"") For this formula its quite short but when I have long formulas with indirect and other nested if formulas the formula gets extremly long and hard to read for other people.
Join Date 05-14-2009 Location Belgium MS-Off Ver O365 v 2402 Posts 13,540
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before ...
Good Morning, I'm currently using the CEILING function to round up to the nearest .5. My spreadsheet is based on square footage, what I need is a formula using the same rounding function but anything less than or equal to 4 is 4.
Should be an easy one. Is there any command usable in an IF statement that checks to see if a cell has a value or text in it? Like IF(A1="text or number", YES, NO). Tried both text and value but those are converters. If not then I guess I'll do things the hard way and make a ton of IF statements within each other.
I could use help with this also, to be specific, I am taking data and assigning it a confidence level. The confidence level is going to be indicated by the use of cell background color, ie a green cell indicates a +/- 10% confidence level and therefore my expected data rande is X+(X*.1) and X-(X*.1) and so on (X being my measured sampled.