Quick Excel Help
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
Are you stuck on Excel or Google Sheets?
Check out some problems solved by our top Experts or click
to post your own problem for free!
hello, if i type 55 cr in numbers then it appears 550,000,000 but earlier in my old HP LAPTOP IT WOULD APPEAR AS 55,00,00,000. now i require in 55,00,00,000 format. please help
Solved by E. C. in 40 mins
Not sure what this called to properly search so I am struggling. I import reports into Excel and get A1 with a name and A2 is blank. Then the following cells come in 2 rows that belong to the name at A1. If I want to sort by name, A2 is blank so I can't keep all of row 1 & 2 info together. Is there a way to say if A2 is blank, copy info from A1? I have 160 pages of this data so I can't just copy and paste individually.
Solved by B. H. in 17 mins
when i key in $19.99 i dont want to have to hit the decimal. i would like the cells to know that if there are 4 numbers, the decimal automatically goes 2nd to the right. and if i put 19999, it will key in 199.99
Solved by G. A. in 32 mins
Hello, I need to figure out how to link a cell in one sheet to a cell in another sheet, but those cells need to link if and only if they have the same part number in a different cell how do I do this?
Solved by A. U. in 21 mins
I need a formula to return 3 if value in column A is equal to value in column B and return 1 if value in column A is greater than value in column B
Solved by B. E. in 20 mins
conditional format required for cell if another cell is 100% and cell is less than 100%
Solved by A. S. in 11 mins
I have a schedule for my colleagues and I would like excel to automatically remove their break time from the allocated hours I have inputted for that week, based on the amount of hours they have set within that day. So if they're doing 4 hours, they get no break. If they're doing between 5 to 8 hours, they get 30 minutes. 9 hours or more they get 45 minutes.
Solved by S. J. in 52 mins
Filled cell should autofill formula. So if B5 has is shaded, filled with a number or check it will provide a x1.2 to the formula for the end result
Solved by K. U. in 22 mins
I need a formula to add E2 with H2 and I2 only if the value in E2 is greater than 20
Solved by E. L. in 6 mins
Im trying to enter a percentage of a number for different scenarios. Example = if a1>= 254 *"10%","*5%"
Solved by C. B. in 9 mins
Got it! Your question will be answered by an Excelchat Expert. Hang tight for 30 secs while we redirect you.
Save time by asking instead! Most questions solved and answered in 10 minutes.
Post your problem and you’ll get expert help in seconds.
Your message must be at least 40 characters
Free trial ends in
00 days 12 hours
Try for free