e11

A formula in cell E11 that would say E11 = H11+ (ALLDATA!BC6*2) IF ALLDATA! T6/220<5.5, THEN ALLDATA!BC6 =0 IF ALLDATA!T6/220>11.5, THEN BC6=BE6 IF ALLDATA!T6/220<5.5 THEN H11=H12

Hi everyone, Here is the code I have so far: Sub ValuePaste() Dim loLastRow As Long ThisWorbook.ActiveSheet.Range("E9").Copy With Workbooks("test.xlsx").Worksheets("test") loLastRow=.Cells(Rows.Count,3).End(xlUp).Row + 1 .Range("C & loLastRow).Paste.Special Paste:=xlPasteValues EndWith End...

Hello, any help would be greatly appreciated. I am trying to add together 5 days worth of time data to give a total. For example the data is (E10) 06:11, (E11) 09:29, (E12) 08:13, (E13) 08:52, (E14) 08:46 to total 41:31 and not 17:31

Hi I am trying to setup a dynamic range using offset in name manager which will select every 6th cell in a row starting at E11 i.e. E11, K11, Q11 etc would be selected but only where data is present Any thoughts please.

hi! i wish someone could help me. i have problem with a cell (actually F11) with the formula =if(E11>=0.75,"mastered",if(E11>=0.25,"nearly mastered",if(E11>=0,"least mastered",""))) and the formula in cell E11is =iferror((D11/C11),""). my problem is that when ever E11 is in error the value in...

Hi This is my function, but I need it not to calculate anything when one of the cells is blank (either E11 or G11). How would I do this please? =IF((AND(E11<=50, G11="Proficient")), "Yes", "No") Thanks!

I have this formula and I cannot get it to work for me =IF(E11="",0,SUM(F6:M6,B11:E11)) the cell which the formula is in is E15, so if E11 has no value then I want E15 to be "0",, If E11 has a value then the formual SUM(F6:M6,B11:E11) needs to apply. Thank you. E6 5,000 E11 0 E15 0 E6...

Hello, I have this formula =IF(E11="","",SUM(F6:M6,B11:E11)) which works, but the cell the formula appears in is E15 What i am trying to do is that if cell E11 have no value in then cell E15 to be "0", the formula I have works when E11 has a value in it adds to E15 ok. But I need E15 to be...

Hi friends, I have the following data from cell A1 to E11. I want to extract all the Product name which is >=1 and <=-1 for chennai in B15, and for Mumbai in C15, for Delhi D15 and for Bangalore E5. I wish to do this using excel formulas. Please help :confused::) <tbody> Porudct Sales rate...