Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
=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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Return lowest quantity | Excel Worksheet Functions | |||
RETURN intersecting value with known horizotal & vertical?? | Excel Worksheet Functions | |||
Return the smallest value | Excel Worksheet Functions |