| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF's with Logical Arguments - Doing something wrong here
What exactly do you think that part of your formula is doing ?
I13=E13*E14*1000/$E$7 -- Regards, Luc. "Festina Lente" "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 | |||
| 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) | |||
| Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more | Excel Worksheet Functions | |||
| Problem with nested logical formula. | Excel Worksheet Functions | |||
Linear Mode
