return value if
 

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.

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.

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

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

Ron

"Micayla Bergen" wrote:

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

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

"Micayla Bergen" wrote:

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