=IF(OR(ISNUMBER(FIND("AMC", A6)),
ISNUMBER(FIND("WES",A6)),ISNUMBER(FIND("WMR",A6))) ,"1","")
=IF(F21,D2)

"Ron_D" wrote:

Please post the formulas so we can view what's happening.

Thanks,
Ron

"Micayla Bergen" wrote:

I have a formula in F2 that returns value '1'. i want my formula in G2 to
return a value if F2 returns '1'. the G2 formula doesnt seem to recognise the
returned value in F2, nor can i sum the returned values in F column. Is there
an option i need to change somewhere?
Thanks Anyone.