c10

I can't get this formula to return value 99 if cell C10 is blank: =IF(AND(B10="H",C10=0),"99",C10) I've tried this: =IF(AND(B10="H",C10=""),"99",C10) and this: =IF(AND(B10="H",trim(C10=0)),"99",C10) The formula only returns the contents of C10 if C10 is populated, but it doesn't return value...

In cells A10 and C10, I have two different calculations with a number total for each cell. In B10, I'd like to have a calculation that looks at A10 and C10 . . . if those two numbers are the same or within 1 of each other, B10 is bright yellow. If A10 and C10 are different by more than 1, B10...

I am trying to accomplish the following; Cell C11 Change to 50%, 40%, 35% or 30% if cell C10 is 50,000, 100,000, 150,000, 200,000

Have a first and last name in cell C10. Recorded a macro to use TextToColumns. Selection.TextToColumns Destination:=Range("C10"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=True...

<colgroup><col><col><col></colgroup><tbody> A 1 5 B 0 C 6 2 5 1 4 3 0 3 3 4 2 2 3 5 7 6 9 6 4 2 9 7 9 8 1 8 5 2 3 9 5 7 7 </tbody> 10

THE DATA A 1 hello 2 my 3 excel 4 world DESIRED RESULT in col C using Formula increment C 6 Hello 7 8 my 9 10 excel 11 12 world 13 What I attempted C6 =$A1 C8 =$A2 SELECT C6-C9 and drag 2 rows to increment formula RESULT C10 =$A5, not the desired C10 =$A3 Any help would be...

Currently i am working with a spreadsheet that has 18 columns and i am checking the value of c10 cell and then highlighting the row based on that 1 cell. I would like to improve on this by adding a second color and a second cell reference. My vision is to check r1c5 and r1c10. And if c5 is >...

Hi. First time posting so please be gentle. I am new to VBA and trying to get a grip of it, and having searched everywhere i cannot find anything that will solve this problem. I have two identical workbooks containing numerical data: Master01 Data01 I need a macro that takes the data in each...

Hello Guys. I want to disable macro if cell C10 in sheet1 is not blank. It should be active if C10 in sheet1 is blank. I am running macros from ribbon. The macro name i want to disable is "Sub Start(control As IRibbonControl)". It should be applicable to the whole workbook. Thank you.

say cell A2 having value of B5 ( this B5 is a cell address) cell A6 having value of C10 ( this c10 is a cell address) Private Sub CommandButton1_Click() ActiveSheet.Range("A2:A6").Copy End Sub Here in the code there will be A2 and A6 only as their cell value represents my desired value Now...

Hello All board member, It seems from very very long time on board..Happy to questioning.. Ok.. I have question like, after my c10 range, whatever be the rows data are there, will be clear.. Can anyone help me on this..

I am copying the following formula down a column and need the f2 to remain constant instead of canging to f3,f4 .... =IF (OR (C10=0),"",INT (YEARFRAC (C10,F2))) Can anyone help?