simplify formula

Hi, I want to write a formula that computes the normalised Gibbs entropy, which is computed as follows: The values that I want to test this for are located in column Z, AD, AH, AL, AP, AT, AX, ..... CL etc. so 3 columns are skipped every time. I want to test for values 0 - 10. I already...

Hi (again) I am sure this is something to do with array or range, but i cannot get my head around it. There must be a simpler way to express the "if(or(" part of the following formula (in red)...

Hi everybody, I asked my intern to solver a problem about trigonometry. However, the equation he developped work, but are incredibly long and complicated for nothing. I was wondering if there's was a way to shorten - simplify a excel equation. Here's is the equation .... ...

Hi i knocked up this formula to get the sum of a columnof cells only if the values in the cells next to them were less than 20. =(IF(J15<20,K15,0)+IF(J16<20,K16,0)+IF(J17<20,K17,0)+IF(J18<20,K18,0)+IF(J19<20,K19,0)+IF(J20<20,K20,0)+IF(J21<20,K21,0)) I'm sure there's a way of condensing it but...

My formula is super long and I know there has to be a way to make it shorter, probably with a VBA loop, but I'm sick of looking at it, and I don't know where to start. General Setup: Sheet 1 has 3 cells: Cell B has a VLookUp to Sheet 2, which returns a number. Cell C uses the number to print...

Is there anyway to reduce this formula into a simpler form? =IF(AND(ISBLANK(C11),ISBLANK(E11)),"",G10+SUM(C11,E11)) For instance, any way to combine =IF(AND(ISBLANK(C11),ISBLANK(E11)) this part of it?

I built a formula to retrieve a date from a list. {MAX(IF(AM2='POs Recpt Date '!A:A,'POs Recpt Date '!E:E)} <colgroup><col><col><col><col><col></colgroup><tbody> PO Value DC PO Vendor PO Date recvd $18,022.20 LIV 217550 XXX 1/0/1900 $19,050.00 LIV 217603 XXX 8/7/2015 $19,050.00...

When I use the function: =TODAY() it inserts today's date but in American format? I can use: =TEXT(A1,"dd/mm/yyyy")to change this into the format I want but is there a way to make this all occur in just one formula so that I don't end up with 2 cells containing dates?

please help simplify this formula, in any way possible. thank you very much...

So my code is working great, but looking at my code I can't help but think that there must be an easier way to loop through the script so it isn't so repetitive. Any thoughts? Sub Macro1() Dim ActSheet As Worksheet Dim JUNCTION As String Dim BOC As String Dim Amount As String...