Excel Formula

[Supa Dexta]

I dont know a whole lot about excel, but this seems straight forward - yet I can't get it to display properly

=IF(F4="F","",H4*(IF(F4="M","0",H4))*(IF(F4="", "", H4)))

Basically F column is tracking Male or Female, M = 0, F = a blank cell

However continuing on down the page, If I havent typed M or F in the F column and the cell is blank, I want the output to remain blank in H column. Under the current formula its giving me 0 if blank, or M and F works fine displaying nothing.

[blitz]

Add another if statement at the start to check from a blank cell

=if(F4="","", existing formula)

[Enhance]

You can also use:

=IFERROR(IF(F4="F","",H4*(IF(F4="M","0",H4))*(IF(F4="", "", H4))),"")

[flipstah]

Necro bump!

If you have a string of words in one excel cell such as,

"3x bananas 4y apples 6s flowers"

How can you pull "4y" out of the string and into another cell if the associated keyword is "apples"

[Mogg]

This quote is hidden because you are ignoring this member. Show Quote

Necro bump!

If you have a string of words in one excel cell such as,

"3x bananas 4y apples 6s flowers"

How can you pull "4y" out of the string and into another cell if the associated keyword is "apples"

It would be better if you post a better example of what you are trying to accomplish. There are many ways to do this depending on a few things (is string always same length? Always separated by space?)

For your above example the easiest way would be:
Data Tab>> Text to Columns button>> Switch to Delimited >>Unclick tab, click space box>> next >> next> Finish. This will put each word separated by a space into a cell i.e 3x in A1 bananas in B1 4y in C1... if you are only concerned about apples then just click do not import on other cells and "3x bananas 4y apples 6s flowers" will be replaced by "apples"

[Sal0]

[QUOTE=Mogg;4763461]It would be better if you post a better example of what you are trying to accomplish. There are many ways to do this depending on a few things (is string always same length? Always separated by space?)

Not enough information as Mogg mentioned. If you need a formula, you could use the find, left, right functions.

Cell A2 - "3x bananas 4y apples 6s flowers"
Cell B2 - =RIGHT(LEFT(A2,FIND("apples",A2)-2),2)