explain

Hello all. Each of the 2 below formulas works on their own =IF(A11<>"",IF(AND($E$7>=.4,$E$7<1),$C$7*$D11,"") =IF(A11<>"",IF(AND($E$7>=.4,$E$7>1),$C$7*$F7,$C$7*$F7)) I need to combine these, but I can't seem to do it. Can anyone help? To further explain what I am trying to do... I am trying...

Tricky one to explain this. I have a file where I need to know if any row of dates are earlier than the rows before. The code first needs to look at column K and all the numbers that match. In the example below I have highlighted in yellow the ones that are incorrect. If you look at N6&7/O6&7...

Hi, can anyone please explain what the two "diamonds" are on rows in columns D & J, how they were created and how to remove them? Asking for a friend so don't know what they've done to create them? Many TIA

Hi Sorry if that is off topic. I want to know the difference between these 3. I google it but no one seems can explain it in easy and understanding way. Thank you.

Can someone explain Add-Ins to me? What they are most useful for, etc?

Hi Everybody, I'm looking for a formula to look at duplicates in column A and return the lowest # in column D from those duplicates. I also need it to ignore the cells with "#N/A". The answer & formula will be in column E. Hopefully, I've explain that well enough. Below is a link to a screen...

Hi Everybody, I'm looking for a formula to look at duplicates in column A and return the lowest # in column D from those duplicates. I also need it to ignore the cells with "#N/A". The answer & formula will be in column E. Hopefully, I've explain that well enough. Below is a link to a screen...

The below formula part of another thread find 1st Instance. Can someone explain 1 Plus. D2 =1+SUMPRODUCT(($A$2:$A$10=$A2)*($B$2:$B$10<$B2))

When I enter this code, it works.. Rows("26:37").Hidden = True Rows("49:52").Hidden = True but when I enter it like this, it doesn't. Can anyone explain? Rows("26:37", "49:52").Hidden = True

Hello I'm not quite sure how to explain it. I want a simple formula of payments, in this example $100 in 5 months means $20 a month. But I don't want to be adding formulas every time I change the months for example <tbody> Value 100 Months 5 1 2 3 4 5 6 7 8 9 10 11 12...

Here is my Google Sheet, you can show your magic here. It would be great if you explain how your formulas works in layman's terms. Thanks!

Hi I have been given this formula but I don't understand some parts in the false section, please could someone explain the parts of the formula to me in detail, especially what the (1- means many thanks in advance {=IF($U2="Fuel...

Hello, I need to look up certain parameters on another table and have it provide a result. I cant even insert a table to explain, bad start. Can you help? <colgroup><col><col><col></colgroup><tbody> </tbody> <colgroup><col><col><col></colgroup><tbody> </tbody>

Hi All, I am trying to sort column 3 (C) on a pivot table but it wont let me. I can sort the first but not any other can someone help me and explain what i am doing wrong. this is what i have. So i am wanting column C to be in alphabetical order.

Hi With FormExtraSheets.ListBoxExtraSheets ActiveWorkbook.Worksheets(.Value).Delete End With - subscript out of range With FormExtraSheets.ListBoxExtraSheets shtName = .Value ActiveWorkbook.Worksheets(shtName).Delete End With - works fine Could someone explain to me...

=SUM(IF(IF(MATCH(Table1[Ivoice],Table1[Ivoice],0)=ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]]),(ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]])),0)<>0,Table1[Totals],"")) Can someone break this down, and explain this formula to me. I know what it does, but not clear of the meaning...

=LOOKUP(10^9,--MID(J43,MIN(FIND({0,1,2,3,4,5,6,7,8,9},J43&"0123456789")),{1,2,3,4,5,6,7,8})) Here is the formula, I am confused about the 10^9 and the -- that are listed in the formula. Can someone break it down and explain the meaning behind the inputs please? Thank you...

Hi all, Desperate for help before I launch my computer out the window... I am self taught on spreadsheets.. I am getting there but im struggling with one thing. I don't know what formula-code I need to input into my spreadsheet. When I change the date I want the information associated with...

I have this excel formula and i dont know if there is an error or not. if someone could explain this if its not an error that would be great. IF(1>=1, IF(2<>1,1,3,),2)+1

Explain formula: IF(NOT(AND(1>1, 2>1)), 1, 2) + IF(NOT(OR(1>1, 2>1)), -1, 1)