IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present

Here is an Excel Formula for creating an Excel Form which will apply separate Math Formulas depending on the input, and if no input is entered a default text will be displayed requesting input. In this case, we'll apply one mathematical formula if the form is filled out by a Male, and a Separate mathematical … Continue reading IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present

Recording a Macro for Separating Text to Individual Pages

First, Remove 'Manual Page Breaks' by Searching for ^m and leaving Replace blank Developer Tab > Record Macro Enter a Name without any Spaces Click on Keyboard, Give it a Short-Cut, like Ctrl+1 and click "Assign" Under "Store Macro In.." select the current document, or select normal to save it to all documents Click "Close" … Continue reading Recording a Macro for Separating Text to Individual Pages

Making Blending Modes appear Separate & Permanent, which Overlap its Underlying Layer in Photoshop

If you blend, layers, such as with Multiply or screen, and you want to make the layer you blended keep its current blended appearance while being lifted off the underlying layer and having properties of its own which overlap the layer, do the following: Paste the top layer on the image and choose multiply for … Continue reading Making Blending Modes appear Separate & Permanent, which Overlap its Underlying Layer in Photoshop