return value if

[Guest]

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.

 

[Guest]

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

Thanks,
Ron

 

[Guest]

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

 

[Guest]

Micayla,
Take out the quotation marks around the 1 in the F2 formula. It's returning
a string rather than a number.

Ron

 

[Guest]

Also, what does the G2 formula do? If F2=1, then show content in D2? If so,
the formula should be =if(F2=1,D2)

Ron