Hello Excellers time for some more #formulafridayfun. How about today we look at using the DATEVALUE function to convert text values in our Excel worksheets to a REAL Date value. First let's look at the DATEVALUE syntax which is really straightforward. DATEVALUE =DATEVALUE(date_text) where date_text is a required argument which is a text string representing a date. Excel will return a serial number which represents a date in Excel. There are a couple of benefits to … [Read more...]

## Formula Friday – Quickly Convert Formulas To Cells Values In Excel

Happy Friday Excellers, and welcome back to some more #formulafriday fun. Today let's take a look at how to easily display only cells values and not the Excel formulas that you have written. Let's take this Excel formula I have written as as example- So, we only need to hard coded cell values not the formulas in Column D. I have two ways to do this. Method 1. Use Copy Paste Special You probably know this method. Copy the cells that contain your formulas by hitting CTRL+C … [Read more...]

## Formula Friday – Is That Odd? Testing A Number With ISODD Function.

I kind of like odd things always have done, even this Function looks odd don't you think?....it maybe odd but heck it works if you want to identify odd numbers in you data. (If the value you are testing is not a number then Excel will return the #value error). If you want see see all of the blog posts in the #formulafriday series then you can click on this page right here. ISODD Syntax =ISODD(number) Where number is the value to test and is a required argument. Let's … [Read more...]

## Formula Friday – How To Highlight All Cells That Contain A Formula Using ISFORMULA

Hello Excellers Happy Friday and it's time for some more #formulafriday fun. Today let's look at how to use the ISFORMULA function to achieve the following To test a cell reference to see if it contains a formula Conditionally format a cell reference if it does contain a formula. This is really useful if you need to see all of the cells that contain formulas at once on your Excel worksheet. You could use the GOTO option in Excel, but in this way you can highlight your formulas … [Read more...]

## Formula Friday – Calculating The Percentage Of A Target Yet To Be Achieved.

Hello Excellers time for more #formulafriday fun. Ever need to know how much you need to score on your last assessment to reach your target score so you know exactly how far away you really are from passing your assessment? Let's take a look at a working example. Let's say there are four parts to your assessment based on Excel, Word, PowerPoint and Access. Part 1 represents your Excel assessment Part 2 represents your Word assessment Part 3 represents your PowerPoint … [Read more...]

- « Previous Page
- 1
- …
- 5
- 6
- 7
- 8
- 9
- …
- 21
- Next Page »