Check out some problems solved by our top Experts or click here 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