Does anyone know how I can add the "#####" into a formula? essentially what I'm trying to accomplish is adding 5 leading spaces before returning value.
e.g. If the returning value is "Students" then it should look like this
Students (5 spaces before the returning value)
Students (no...
I am using a formula in which the results "low", "medium, or "high" will appear (in column U) based on the numerical value that is entered in another cell (in column T).
=IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH",""))))
It works perfectly, however the word "FALSE" is shown...
Hi all,
I have a report that I am trying to automate as it just takes far too long to complete it manually. As main reference to edit my data, I have different titles from different jobs which the naming is not consistent. What I want to do, is identify which jobs are not in UK language, and...
Hi everyone,
I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag.
The combinations on this are driving me crazy and I...
Hello,
I'm trying to replace 100 cells in a column that has different values. The result will be in another column that identify the first letter of that cell and replace with one the 3 names in all selected rows (Mary, Thomas, Hilton). I believe a VBA code would be easier than a nest formula...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.