pdvsa
asked on
IF And
Experts,
I am trying to figure out why the record highlighted in Red towards the very bottom does not state an amount in Column L row 197. There is comparing of dates and such and I am not certain exactly why the record above does state a USD Equivalent but the one hightlighted in red does not. Can someone make sense of that formula?
thank you
row 197, column L
the statement is as follows (too large for me to understand)
=IF(AND($F197>$L$19,$C197< $L$18),IF( $G197="USD ",$H197,(I F($G197=$H $4,$H197*$ L$4,(IF($G 197=$H$5,$ H197*$L$5, (IF($G197= $H$6,$H197 *$L$6,(IF( $G197=$H$8 ,$H197*$L$ 8,(IF($G19 7=$H$9,$H1 97*$L$9,(I F($G197=$H $10,$H197* $L$10,0))) )))))))))) ,0) LCcost.xls
I am trying to figure out why the record highlighted in Red towards the very bottom does not state an amount in Column L row 197. There is comparing of dates and such and I am not certain exactly why the record above does state a USD Equivalent but the one hightlighted in red does not. Can someone make sense of that formula?
thank you
row 197, column L
the statement is as follows (too large for me to understand)
=IF(AND($F197>$L$19,$C197<
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER