return value if

M

Micayla Bergen

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.
 
M

Micayla Bergen

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

Ron_D

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

Ron
 
R

Ron_D

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
 
Top