Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF's with Logical Arguments - Doing something wrong her
What cell are you entering the formula into?
-- Brevity is the soul of wit. "ConfusedNHouston" wrote: Thanks Dave, but I must still be doing something wrong. Here's the statement I used, patterned after yours below but using the apprpriate cell references from my spreadsheet. Excel says that the formula refers to itself, creating a circular reference. My guess is that I have a syntax error between the two repeating mathmatical arguments: =IF(AND($F$28=100,E180,F180,G18=E18*F18*1000/$E$7),E18*F18*1000/$E$7,"") All help is appreciated... "Dave F" wrote: Use AND: =IF(AND(F28=100,E130,F130,I13=E13*E14*1000/E7),E13*E14*1000/E7,[else what] See my response to your other post. With this question, you don't specify what you want returned if the critieria are NOT matched (this is the [else what] portion above. This could be as simple as returning a blank, "" , or it could be a text message, or another logic test. Dave -- Brevity is the soul of wit. "ConfusedNHouston" wrote: Similar to a post of a few minutes ago but actually a different problem: Here's the formula: =IF($F$28=100,IF(E130,IF(F130,I13=E13*E14*1000/$E$7,""))) I'd like it to throw the value of the expression E13*E14*1000/$E$7 into the cell if all three conditions are met. Even when all 3 conditions are met, I get a cell value of FALSE. Is it syntax or am I missing something else. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
How do you use more than 7 arguments in a logical IF? | Excel Worksheet Functions | |||
Nested subtotal figures in wrong order | Excel Discussion (Misc queries) | |||
I have run out of arguments for nested IF statement | Excel Discussion (Misc queries) | |||
Problem with nested logical formula. | Excel Worksheet Functions |