ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Nested IF's with Logical Arguments - Doing something wrong here (https://www.excelbanter.com/excel-discussion-misc-queries/120624-nested-ifs-logical-arguments-doing-something-wrong-here.html)

ConfusedNHouston

Nested IF's with Logical Arguments - Doing something wrong here
 
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.

driller

Nested IF's with Logical Arguments - Doing something wrong her
 
i maybe confused, also

=IF(AND($F$28=100,E180,F180),E18*F18*1000/$E$7,"")

happy holidays



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com