explain

Hi I want to understand these codes under number custom formatting. For example what does #,##0;-#,##0 mean or what does #,##0.00;[Red]-#,##0.00 mean. Is there any website/video explain step by steps what these codes mean and how you can created your own. I have seen some video/articles...

Ok, so I need to highlight one cell based on a lot of different criterions. https://www.dropbox.com/s/w2scs59ip464kvm/EXAMPLE%201.xlsx?dl=0 I hope this example workbook can explain it better.

Can anyone explain this formula and what it is doing? The OFFSET is confusing me. =IF(OR(ISBLANK(M67),ISBLANK(C67)),"",IF(OR(ISBLANK(N67),Q67=0,Q67=-1),(L67-M67)*100/D67,((L67-M67)-(AVERAGE(OFFSET(O67,(Q67+1),0)/300*N67,OFFSET(O67,(Q67+(IF(OFFSET(A67,Q67,0)="SEED",0,1))),0)/300*N67)))*100/D67))

Hi Since I am less so familiar with this statement, then I can not do much to do a series of tests with this statement. let's say there's a code like this If Not X is Nothing Then What does this code mean. Is there anyone who can help me explain it, and give me a little example using this...

Can someone explain why in the formula: =COUNTIFS(Sales,">="&H1,Sales,"<"&G2) quotes are used? I know about concatenation but why are the logic signs in quotes and why couldn't the formula just as well be written as: =COUNTIFS(Sales,>=&H1,Sales,<G2) ??? I know words that appear in quotes...

hello guys im trying to modify this FIFO file here in this page, i need someone to explain the =table(,h2) on column M heres the link: Office FIFO calculation with Excel Data Table thanks guys

Someone please explain me this formula...what exactly it will do. =IF(COUNTBLANK(Table1[@[L1-Uber]:[L9-Account Type]]) = 18,2, MIN(Table1[@[L1-Uber]:[L9-Account Type]])) L1-Uber and L9-Account Type being column names. Thanks

Hi everyone. I wanted to find a fumction that would return the last value more than zero form a particlular column. I found this formula on "xl-central.com" — =LOOKUP(2,1/(A2:A10<>0),A2:A10). It works perfectly, but I can't understand how it bloody works!!!! And it annoys me as hell! Could...

Hello Friends, I have tried to explain my question in this video. Please help me get the answer. Excel Question - YouTube

Hi, I've got this code to copy the formula in F1 below for the amount of values in G1. But I think that in my last line I somehow give the order to copy the value of F1, instead of the formula of F1. At least, that's that happens in my worksheet. Can someone explain to me what I'm doing wrong...

Hey everyone! I'm just starting out with excel and I'm working on formulas. What I'm trying to do is obtain the average of one cell across multiple sheets. Someone suggested a formula (which I failed to ask what it does) and was hoping that someone here could explain it for me, if you would...

Hello everyone, I'm a mega noob a Macros and i want to learn, i had a question how to paste stuff in the next availbale free space not over writting so i googled found your forum which i now love and added to favorites. I saw this response and just modified the values for my use and it works...