View Single Post
Old 20-10-2006, 17:53   #2 (permalink)
chiqo
theunknown
 
chiqo's Avatar
 
Join Date: 18 Aug 2006
Location: europe
Posts: 959
Default Re: Microsoft Excel help

Donīt understand this .. sry

What would you do with this list? You wanna evince if a horse is in the race or what?

Your formula IF(A1=sheet2!A5,"YES","") shows the content cell A5 on sheet2 if there is a "YES" in this cell.If not thereīs nothing in.

This kind of formula isnīt possible with if/then

Quote:
Instead of doing a formula for IF A1=A2,A3,A4,A5
Because you built the form only with 1 operation .. I think ..
__________________
www.gamblers-delight.de
chiqo is offline   Reply With Quote