give

Hi Where can I find a list of all fonts? the link below does not give me the list https://docs.microsoft.com/en-us/office/vba/api/excel.font.name Thank you very much.

I've discovered this thread from a little time, so if it's possible i post another doubt. I have this formula (really is longer but if a part is correct i suppose that all can be correct as well) =IF(D15<>0,5 +IF(E15<>0,5 +IF(F15>0,5))) I wanna have a total that give me a value if any,one,or...

I was using a CDO sub to send mail and it work great. I now have upgraded my computer and bought the newest subscription for Excel. I am not sure what happened but the sub does not work any more. I am hoping someone will be able to give me some code that will work. This has ruined my entire...

Hello! I need help regarding my file. I am working on my cheque warehousing file. I have a sheet that contains all of my warehoused cheques.I need to create a file wherein it can give me same dated cheques in one sheet. Can you please give me tips on how to do it. I used vlookup but its tedious...

Hi, I have this IF formula but give me error "#VALUE!" here is the code: =IF(AND(L4="AB/BC","QC"),K4/1.05,K4/1.13) here is the data:

hi all.. how to make CF formula with condition like this : in absolute number (20% as parameter) if C2=>20% - give this cell Red color if C2=>-20% - give this cell Green color <tbody> data expected result (Hightlighted) 25% Red -25% Green </tbody> any help, greatly...

I have a column of number values and need to find a give amount which could be a multiple of 1 or more of those numbers. Is this possible in excel?

Hi Why this formula is giving me 0 =IF(E2>50, ,) I thought it should give me True if E2 > 50 and False if E2 < 50 because I did not specify what would be if the condition is True or False. Thank you very much.

=IFERROR(O7-O6,"") Hello how can I avoid to see the result if there is no value in the cell of O7? The formula should give me result if there is number in the cell O7, is it possible?

Hey all, I am cracking my head without finding a logical solution for this problem. This is a small picture of my database (on the left) and I created a pivot table (on the right) to summarize this information. I would like excel to get the lowest number from the column G (date) and insert it...

=IF(COUNT(E3:F3) = 2, MOD(F3-E3,1)-"8:00", "") Hello, The formula given above calculating the extra hrs after 8 hrs. Is there any way to change it if there are entries below 8hrs the formula will give me the negative result? Sample 14:00 => 01:00 = 3 14:00 => 21:00 = -1 Many Thanks

Cant figure out why i am unable to get the correct response if 3 conditions state Active then give me Active ,if they all do not give me Inactive I am building this report from Excel to Access I am trying to duplicate this code in Excel...

Hi all, Can someone help give me a formula that would imitate the PV function of excel. For example, if I use the below formula, then I would get an answer of $10,000 =PV(5%/12,60,188.72) What I need is a formula that would give the same answer without using excel's built-in PV function...

Can someone give the way to SUMIF a range of numbers based on formatting alone?

Hi, im trying to build a formula that can check a date and time stamp is between two other calculated date and time stamps. If this was a value issue I would use a IF statement e.g. answer 10 between 5 and 20 =IF(and(a1<=5,a1>=20,"Yes","No") But when it comes to date and time stamps I want to...

Hi. Can you give Excel a target to get to when picking from a list of numbers? e.g. if the list is 1,2,3,4,5,6,7,8,9 and the target set is 22 can you get Excel to pick a selection of numbers to give you 22 - 2,5,7 & 8 for example? Can this be further manipulated to give you the target with a...

What would be the correct formula for IF a cell contains text x OR contains text Y, then give me Z value. Right now I have: =IF(SUM(COUNTIF(A6,{"BSC-NCORP-A","BSC-CORP-A"})),"BSC","CIG") But I am only getting the CIG value for everything.

I have the following data: <tbody> A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses </tbody> Whenever a team wins, a 1 is entered manually into Column B or Column D...

Hi, to all members of this great forum. Crossposted : https://chandoo.org/forum/threads/total-by-puestotrabajo-wrong-calculation.41915/ The idea of ​​the table that I present in the file is to distribute a quantity of KG of production in several Puestos de Trabajo, through participations. I...

Hello, Forum, I am unable to find a VBA which would select cells which contain specific characters in a range. Could some give a hand? Thank you for taking the time.