significant

Hello, I would like to write a macro to return values in adjacent cell if a cell contains certain text. For example, if D2 contains any of the following, write the corresponding value in E2; same for D3, D4, etc.: If D2 contains "REG_EU", write Europe in E2 and/or If D2 contains "CN", write...

I am working on some vlookups from a Pivot table that has five results on them; however some of the results are null, so the column disappears. I have been able to link it to the grand total, which is what I want, just not to sure how I can get it to link on the columns. This is my statement...

Hi, Is the a function or formula I could use to ROUND UP a number to just 1 significant figure, which must be either 1, 2 or 5? For example: 1.3 -> 2 2.4 -> 5 7.1 -> 10 11 -> 20 21 -> 50 52 -> 100 120 -> 200 219 -> 500 560 -> 1,000 I've tried many combinations of MROUND and ROUNDUP, CEILING...