Thread: Nested IF's with Logical Arguments - Doing something wrong here
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
  
Posts: 41
Default 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.
Reply With QuoteReply With Quote