Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to write a formula with IF & AND & OR, (I think)
In english:
Cells in Column K contains one of the following values; .25, .50, .75, 1.00, 1.50, 2.00, 2.50, 3.00, 4.00, 5.00, 6.00, 8.00 & 12.00. Cells in Column I contains one of the following values; Valve, H&B, Valve, Ball & Swing Check and Valve, Ball, 3-Way. Cells in Column B contains one of the following values; N/A, CFM, Make Cell AB10 = 8 Cell AB11 = 4 The task I want to do is: Write a formular which: Inputs the Value of 0 into a cell if the Value of Cell B40 is equal to N/A. or Inputs the Value of Cell AB11 into a cell if the Value of Cell B40 is not equal to N/A AND the Value of Cell K40 is less than 4 and the Value of Cell I40 is not equal to Valve, H&B. or Inputs the Value of Cell AB10 into a cell if the Value of Cell B40 is not equal to N/A AND the Value of Cell K40 is greater than or equal to 4 OR the Value of Cell I40 is equal to Valve, H&B. I have started the formula and it works good so far, but I don't know how to incorporate the multiple scenarios. My formular so far is: =IF(B40="N/A",0,$AB$10)) Can you give me a clue on how to write a formula like I the one I have eplained? Darrell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to write a formula with IF & AND & OR, (I think)
=IF(B40="N/A",0,IF(AND(K40<4,I40<"Valve, H&B"),$AB$11,$AB$10))
-- David Biddulph "Dr. Darrell" wrote in message ... In english: Cells in Column K contains one of the following values; .25, .50, .75, 1.00, 1.50, 2.00, 2.50, 3.00, 4.00, 5.00, 6.00, 8.00 & 12.00. Cells in Column I contains one of the following values; Valve, H&B, Valve, Ball & Swing Check and Valve, Ball, 3-Way. Cells in Column B contains one of the following values; N/A, CFM, Make Cell AB10 = 8 Cell AB11 = 4 The task I want to do is: Write a formular which: Inputs the Value of 0 into a cell if the Value of Cell B40 is equal to N/A. or Inputs the Value of Cell AB11 into a cell if the Value of Cell B40 is not equal to N/A AND the Value of Cell K40 is less than 4 and the Value of Cell I40 is not equal to Valve, H&B. or Inputs the Value of Cell AB10 into a cell if the Value of Cell B40 is not equal to N/A AND the Value of Cell K40 is greater than or equal to 4 OR the Value of Cell I40 is equal to Valve, H&B. I have started the formula and it works good so far, but I don't know how to incorporate the multiple scenarios. My formular so far is: =IF(B40="N/A",0,$AB$10)) Can you give me a clue on how to write a formula like I the one I have eplained? Darrell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to know how to write a formula | New Users to Excel | |||
How to I 'write-through' a formula | New Users to Excel | |||
What is the best way to Write this Formula | Excel Discussion (Misc queries) | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
how do I write a formula for? | Excel Discussion (Misc queries) |