Hello,formula for multiple conditions but as my Excel is not having IFS formula i want some formula which i can replace with.=IFs(AND(E4>=MIN("00:01"),E4=MIN("8:00"),E4=MIN("12:01"),E4=MIN("15:01"),E4=MIN("19:31"),E4

]]>Hello! I have a formula as follows

But I only want to average those numbers when there are 5 or more such instances of positive numbers.

Tried this but it doesn't work:

I'm guessing this has a simple solution, but I've been thinking about it for awhile and can't figure it out.

]]>Code:

`=AVERAGEIFS(Sheet2!AE:AE, Sheet2!A:A,A1, Sheet2!AE:AE,">0")`

Tried this but it doesn't work:

Code:

`=AVERAGEIFS(Sheet2!AE:AE, Sheet2!A:A,A1, Sheet2!AE:AE,">0", Sheet2!AE:AE,(COUNTIF(Sheet2!AE:AE,">0"))>=5)`

Hello,

I have a column with cost center numbers that are like this:

I want to make a new column where I pull only the last TEN numbers of the column, let's say COLUMN H is those numbers, and COLUMN I is where I want

VT91549009

What would be the formula to do this?

]]>I have a column with cost center numbers that are like this:

76701000VT91549009 |

I want to make a new column where I pull only the last TEN numbers of the column, let's say COLUMN H is those numbers, and COLUMN I is where I want

VT91549009

What would be the formula to do this?

hello,

example is as below

Formula used =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($H$3:$H$5,E3)))))>0,"1","")

example is as below

Formula used =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($H$3:$H$5,E3)))))>0,"1","")

Current Result using formula | |||

content | result | specific text | |

abc rohan fcv ssssb fff ssss eeeel fffll | 1 | raj | |

abc rbl fcv ssssb fff meet eeeel fffll | 1 | rohan | |

raj ddd vvd ssdsd fdfee sxx | 1 | meet |

expected result | |||

content | result | specific text | |

abc rohan fcv ssssb fff ssss eeeel fffll | rohan | raj | |

abc rbl fcv ssssb fff meet eeeel fffll | meet | rohan | |

raj ddd vvd ssdsd fdfee sxx | raj | meet |

I am planning to derive an answer in percentage in excel by using excel formula. Basically, I am trying to select a specific number from a cell, then add that specific number and then divide to get percentage.

For example -

In the excel sheet from total 5 cells - if Cell A1 has 100, Cell A2 has 100, Cell A5 has 100 - then select those 3 numbers from A1, A2, A5 and add them (100 + 100 + 100 = 300) then divide 5 and take that answer as percentage & in this case - 300 / 5 = 60

Can you share a formula by using select or another manner. Thank for your assistance.

]]>For example -

In the excel sheet from total 5 cells - if Cell A1 has 100, Cell A2 has 100, Cell A5 has 100 - then select those 3 numbers from A1, A2, A5 and add them (100 + 100 + 100 = 300) then divide 5 and take that answer as percentage & in this case - 300 / 5 = 60

Can you share a formula by using select or another manner. Thank for your assistance.

How do you create a formula whose output is a BLANK cell?

Remember a cell whose result is "" is not BLANK.

For example, =ISBLANK(IF(1=1,"","")) results in False.

]]>Remember a cell whose result is "" is not BLANK.

For example, =ISBLANK(IF(1=1,"","")) results in False.

Hi

I am trying to find out a formula to input a number if the employee has been absent on particular months. Please see attachment, the last column “Result” should be populated as follows:

If employee absent in April and May and/or June = 2

if only absent in April = 1

if only absent in May and/or June = 2

Thanks

I am trying to find out a formula to input a number if the employee has been absent on particular months. Please see attachment, the last column “Result” should be populated as follows:

If employee absent in April and May and/or June = 2

if only absent in April = 1

if only absent in May and/or June = 2

Thanks

Greetings,

I have an excel worksheet that has the following formula:

Where the F$5:F$156 needs to be replaced by

table: Table1

column: Depth to IE (ft)

If referring to the attached file, it is P5:P14.

I've tried Table[Depth to IE (ft)], but it does not work.

Running Office 365.

Thoughts?

]]>I have an excel worksheet that has the following formula:

Code:

`=COUNTIFS(F$5:F$156,"<" & $O6,F$5:F$156,">=" & $O5)`

table: Table1

column: Depth to IE (ft)

If referring to the attached file, it is P5:P14.

I've tried Table[Depth to IE (ft)], but it does not work.

Running Office 365.

Thoughts?

Dear all,

I have a list of lots of genes and unfortunately sometimes I have more than one gene in one row e.g.:

But I want that every gene is in a separate row without comma, like this (first 4 lines of above example):

]]>I have a list of lots of genes and unfortunately sometimes I have more than one gene in one row e.g.:

ENSG00000063978, ENSG00000125386 |

ENSG00000248323 |

ENSG00000137261 |

ENSG00000235220, ENSG00000204642, ENSG00000137403, ENSG00000237508, ENSG00000229698, ENSG00000206509 |

ENSG00000183826 |

ENSG00000135298 |

ENSG00000185345 |

ENSG00000106066 |

ENSG00000283239, ENSG00000274726, ENSG00000104728 |

ENSG00000153707 |

But I want that every gene is in a separate row without comma, like this (first 4 lines of above example):

ENSG00000063978 ENSG00000125386 |

ENSG00000248323 |

ENSG00000137261 Has anyone an idea? Thank you so much!! |

Hello

I’m learning excel at college and I have an exercise I’m trying to solve for 2 days now and I didn’t succeed.

Employees of a company have different annual salaries. But each salary is always divided into several fixed parts 6000 $ – 9000 $ – 15000 $ - 30000 $ - 60000 $ - Rest of salary if available

Let’s say the annual salary of one employee is 125.000 $. The salary is always divided into several fixed parts 6000 $ – 9000 $ – 15000 $ - 30000 $ – 60000 $ - Rest (5000 $).

(Sum =125 .000 $) and taxes are added on theses parts with different rates:

6000 $ with 2% taxes = 120 $ taxes

9000 $ with 4 % taxes = 360 $ taxes

15000 with 7% taxes = 1050 $ taxes

30000 with 11% taxes = 3300 $

60000 $ with 15 % taxes = 9000 $

Rest 5000 with 20% taxes = 1000 $

Sum of taxes = 120+360+1050+3300+9000+1000= 14830 $

How can I create an excel formula in which I can add the annual salary (i.e. 125.000 $) and get the final tax (i.e. 14830 $)??

It’s been 2 days and I couldn’t figure out how

Any help please

Thanks in advance

]]>I’m learning excel at college and I have an exercise I’m trying to solve for 2 days now and I didn’t succeed.

Employees of a company have different annual salaries. But each salary is always divided into several fixed parts 6000 $ – 9000 $ – 15000 $ - 30000 $ - 60000 $ - Rest of salary if available

Let’s say the annual salary of one employee is 125.000 $. The salary is always divided into several fixed parts 6000 $ – 9000 $ – 15000 $ - 30000 $ – 60000 $ - Rest (5000 $).

(Sum =125 .000 $) and taxes are added on theses parts with different rates:

6000 $ with 2% taxes = 120 $ taxes

9000 $ with 4 % taxes = 360 $ taxes

15000 with 7% taxes = 1050 $ taxes

30000 with 11% taxes = 3300 $

60000 $ with 15 % taxes = 9000 $

Rest 5000 with 20% taxes = 1000 $

Sum of taxes = 120+360+1050+3300+9000+1000= 14830 $

How can I create an excel formula in which I can add the annual salary (i.e. 125.000 $) and get the final tax (i.e. 14830 $)??

It’s been 2 days and I couldn’t figure out how

Any help please

Thanks in advance

I have a master work sheet with thousands of records about 15 columns per record, one of the fields is a date column. I want have separate worksheets for each month based off the date field.

I still want the running master sheet but would like to view the records separately by month in separate sheets… and any changes made to the master sheet continue to reflect on the monthly sheets

This file is hosted on OneDrive so no macros

Sent from my iPhone using Tapatalk

]]>I still want the running master sheet but would like to view the records separately by month in separate sheets… and any changes made to the master sheet continue to reflect on the monthly sheets

This file is hosted on OneDrive so no macros

Sent from my iPhone using Tapatalk

Hello everyone,

I have attached an example of my document, which I have to edit. My task is to get rid of text in the cells and leave only numbers. What formula should I enter into the cells in column B to solve it?Book1.xlsx

I have attached an example of my document, which I have to edit. My task is to get rid of text in the cells and leave only numbers. What formula should I enter into the cells in column B to solve it?Book1.xlsx