-
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.
simplification
-
F
A different formula similar to an If statement
I make use of the If statement a lot and sometimes the formula returns a 0. When the main formula returns a zero I want it to show the dash character so I usually make a formula like this: =If(*Formula* = 0,"-",*Formula*) My main question is if there is a way to not have to repeat the formula...- FedElecQaEng
- Thread
- if "" if & else if satement iferror long formula simplification
- Replies: 11
- Forum: Excel Questions
-
C
Help please
Hey guys (and girls), this is my first post XD... first off sorry if it's in the wrong place and second thanks in advance if anyone can help. =IF($A2=Items!$A$2,Items!$B$2,0) This is the base of my formula, as you can see i'm trying to see if "sheet As" A2 matchs "Sheets Bs" A2 and returning...- CyannideHigh
- Thread
- formula formula and format help excel formula simplification simplify if formula
- Replies: 4
- Forum: Excel Questions
-
D
Verify contents of one row are in another
I have a series of alpha values in column "I" and a control group of values in column "B". I need to find any missing values in column "B" that may exist in column "I". Example- Column I has: P, BS, SS, A, W, P, INV Column B has everything except P and INV. This is a simplification, there...- DougStroud
- Thread
- column inv missing simplification values
- Replies: 1
- Forum: Excel Questions
