-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if's
-
H
Removing unintentional spaces when assembly multiple texts based on IF's
Hi everyone, I want to remove any unintentional spacings in my formula, when visible in the cell. The formula is af following: =A82&" "&'Work Order (Client)'!D46&" "& "on commission (pre-payment)"&""&IF('Input sheet'!B31="Proteomics";",";"")&""&IF('Input...- helloworld_2022
- Thread
- excel if's spacing
- Replies: 1
- Forum: Excel Questions
-
P
IF statement with multiple conditions looking in a few ranges.
Hi all, I am trying to pull the date from the top in row 17 to another sheet if there is a value in row 21 and if Q21 = OCP In addition I want the date to go to one of the following cells and fill from top down. For example in the above picture it would only pull the date from R17, T17, V17...- PumpC12
- Thread
- help nested ifs if's vba "&"
- Replies: 0
- Forum: Excel Questions
-
R
Multiple IF's look up table
So I'm not even sure that title describes my needs. I'm putting together an automated pricing spread sheet and I need help with the last row... so I've got two tables that need to be looked up by earlier inputs. if the process is 'X' I need it to look at one table, if its 'Y' I need it to look...- Rhysgally
- Thread
- if's lookups tables
- Replies: 7
- Forum: Excel Questions
