-
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.
function cells
-
K
"If any one of those cells is blank then do this" How to formulate?
Hi, Suppose I have some data in A2 C2 & E2. In F2 I want to put a formula where it shows that if any one of those three separate cells (which is not in a range) contains a blank then show X in F2. I could do it with multiple nested IF functions (=If(A2="", "X", If(C2="", "X", If(E2="", "X"...- Kukorof
- Thread
- blank cells formula function cells purpose
- Replies: 3
- Forum: Excel Questions
-
H
conditioning in excel based on function
Hi Im trying to use conditioning in excel as following If the values in column (cost price) is <$49.99 then write down $4.99 as shipping price If the values in column (cost price) is >$49.99, then write down $0.00 as shipping price Applies the rule to the other rows Thank you...- happydz
- Thread
- conditioning condtional formatting excel function cells price
- Replies: 2
- Forum: Excel Questions
-
M
SumIFs Problem
I want to give sum of working time at Time Period from Date N1 to Date O1. formula writes in N2 Cell. This is Formula : =SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,$N$1,$F:$F,$O$1) what is problem answer is zero <tbody> <colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col...- maabadi
- Thread
- formula formula & filter function cells function edit()
- Replies: 4
- Forum: Excel Questions
-
L
Automating Text to be formated a certain way.
Hello. I have a question...if i want to create a custom format where text is center aligned, middle aligned, and applying text wrap when info is created into the cell how do i do that? i'm trying to automate it to do this. Also, how can I automate when info gets inserted into a cell the...- Legacy 338295
- Thread
- excel formatting cells function as range function cells
- Replies: 3
- Forum: Excel Questions
