Solved: Need a blank cell as a result

[Tenspeed39355]

Hi guys As a result of a formula I would like the result to be a blank cell if one of the cells is a blank.
Example: The result in G2 is blank when E2-F2 is the formula and F2 is blank. Thanks for your time with this
Max

[mdmackillop]

=IF(F2="","",E2-F2)

[Tenspeed39355]

I tried to send a reply but for some reason I have to start all over.
This is what I am having a problem with.
I need the result cell to be blank if one of the cells used in the formula is blank. Example In Cell L2 the formula is F2-E2. For what ever reason E2 is blank so I would like L2 to be a blank cell. When I do a pull down in column L there will be times that F3-E2 will have numbers in them.
Thanks for your time with this
Max

[Tenspeed39355]

I tried to send a reply but for some reason I have to start all over.
This is what I am having a problem with.
I need the result cell to be blank if one of the cells used in the formula is blank. Example In Cell L2 the formula is F2-E2. For what ever reason E2 is blank so I would like L2 to be a blank cell. When I do a pull down in column L there will be times that F3-E2 will have numbers in them.
Thanks for your time with this
Max

[mdmackillop]

there will be times that F3-E2 will have numbers in them.

If the data is in all rows then

=IF(OR(E2="",F2=""),"",E2-F2)

If E2 is to remain fixed then

=IF(OR(E$2="",F2=""),"",E$2-F2)

[Tenspeed39355]

Thank you again. You guys have saved me again.
Max