Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error with Four Item Conditional Statement

0 views
Skip to first unread message

Epoh Rio

unread,
Jun 18, 2007, 1:09:00 PM6/18/07
to
I am trying to create a summary page of Sheet1. I am having a problem
with a four part conditional statement.

=IF(Sheet1!F2="","",IF(Sheet1!F2="Apple","",IF(Sheet1!
2="Pear","",Sheet1!2)))

Can anyone see the problem with this?

Thanks,

D Hilberg

unread,
Jul 8, 2007, 1:44:04 PM7/8/07
to
Change Sheet1!2 to Sheet1!F2 both places in the final IF.
0 new messages