python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - formula

How can I calculate how many boxes fit inside a bigger box?

I have a defined small square or rectangle, for example 10x7cm and a bigger square or rectangle for example 35x46cm. What formula could I use to calculate the number boxes that fit in the bigger box? ...
test-img

vance

formula

Votes: 0

Answers: 1

Latest Answer

If the formula does not need to be intergrated into a script, you might want to use one of the ready-made calculators available on the web, e.g. this one: https://www.engineeringtoolbox.com/smaller-re...
test-img

OnceUponATime

Excel/Google Sheet Adding Duration to Date/Time

I have data relates to time. I have the start date, start time and end time. My objective is to add the end time to the start date/time to return the End date and time. If the start and end are on the...
test-img

Matthew Smith

excel

if-statement

google-sheets

excel-formula

formula

Votes: 0

Answers: 1

Latest Answer

delete everything in G2:I and use this in G2: =INDEX(IF(B2:B="",,TEXT(B2:B+C2:C, "d/m/e hh:mm:ss"))) in H2: =INDEX(IF(B2:B="",,TEXT(I2:I-G2:G, "[h]:mm"))) and...
test-img

player0

How to restore formulas of table rows to normal state after sorting in excel?

I have a table in excel whose data are resulted by formulas. For example, A2 cells equals E7*2 of another sheet as follow. When I sort table from largest to smallest, the order of formulas changes. F...
test-img

user2987710

excel

sorting

formula

Votes: 0

Answers: 2

Latest Answer

I don't think that you can have both: sorting and referencing other cells. What you can do is to build one formula that does the multipling and the sorting. If you have Excel 365 you can use this form...
test-img

Ike

How can I correctly use the if(and()) function so that I can then drag it down alongside a column of numbers? (Google Sheets)

I use Google Sheets and I have tried to get this formula right for a while now but it always gives me "Undefined" for every cell I drag down to along a column of data. If you're curious, thi...
test-img

wheresjohnnywalker

function

if-statement

google-sheets

nested

formula

Votes: 0

Answers: 2

Latest Answer

Try below formula- =IFS(AND(A1>=0,A1<20),"Risky",AND(A1>=20,A1<40),"Oversold",AND(A1>=40,A1<60),"Neutral",AND(A1>=60,A1<80),"Overbought"...
test-img

Harun24hr

Posts

Questions

Blogs

Jobs