-
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.
ifformula
-
M
IF OR Function
Hi I have the following problem with the following numbers in each cell Numbers A1 100 A2 121 A3 140 A4 98 A5 97 5% Decrease B1 95 B2 114.95 B3 133 B4 93.1 B5 92.15 5% Increase C1 105 C2 127.05 C3 147 C4 102.9 C5 101.85 Current...- martyloo
- Thread
- ifformula
- Replies: 1
- Forum: Excel Questions
-
M
IF formula based on specific values in a range
Hi, I'm trying to average values based on 2 fields. The 1st is straight forward (by date). The second one isn't as straight forward. I need to average column C if column A contains houses numbers 31,36,37,41,46,48 and the date is 01-06-16. So the average of the example below is 9 (houses 31 &...- Mushroomman
- Thread
- andformula averageifs ifformula
- Replies: 1
- Forum: Excel Questions
-
N
Trying to use SumProduct with IF statement from different worksheet in same workbook.
Hi, I am trying to get a count of only non-hidden cells from a new worksheet within the workbook for column b where column a says a specific phrase such as service. I have tried the below, but am not getting exactly what I need and the numbers are not accurate...- NBPuts
- Thread
- ifformula sumproduct worksheet
- Replies: 3
- Forum: Excel Questions
-
G
If forumla question - urgent! Help!
Hello, I've created a document that indicates whether or not we've received a missing document. So you understand the help I need, let me give you the story. There is a due date for us to receive a missing document. So I've entered this formula: =IF(J3<=I3,"TIMELY","LATE") Cell J3 = Received...- GEDMUNDSON
- Thread
- data excel ifformula spreadsheet
- Replies: 2
- Forum: Excel Questions
-
P
IF Formula (Or maybe something else...)
http://www.box.net/shared/0ebhd83tg6 Hi Guys So heres what I want to do. I need to link up the PO's and part values on the Stock out and relevant values to the corresponding PO's on the Consignment stock sheet. (It makes sense when you look at the workbook) For example Column B on the Stock...- Porterrob
- Thread
- complicated formula formula help on an if formula ifformula
- Replies: 2
- Forum: Excel Questions
-
can if formula have another if formula inside the formula? sory for poor english! need help!
If f1 i have a formula as below; IF(OR(H11<13,OR(I11<3,J11<3,K11<3)),"Declined","Accept") if g1 has word saturday can the formula show "Accept" but if in g1<> saturday then the formula ( IF(OR(H11<13,OR(I11<3,J11<3,K11<3)),"Declined","Accept") ) can someone please edit this fomula??? Thanks...- pedie
- Thread
- ifformula
- Replies: 5
- Forum: Excel Questions
-
if formula..please help...
=IF(C4=G13,"Yes","No") is working fine but when i use =IF(C4=G13:G25,"Yes","No") it does not work. What i'm actually trying to do here is that...if C4 value which is date is = any value in range G13:G25 then Y, N. but when i select the range it is not working. please help. THank...- pedie
- Thread
- ifformula
- Replies: 3
- Forum: Excel Questions
-
If formula. Please help. Thank you in advance.
;)if i enter cell a2 = date 7/19/2010 I want cell a1 to show me previous date that will be 7/18/2010. Please advice a formula or a macro otherwise.... Thanks again! Pedi- pedie
- Thread
- ifformula
- Replies: 4
- Forum: Excel Questions
