=if help

[coaster123]

hi this is the formula i have at the moment

=IF('results '!G2=L2,F2,-E2)

this works fine but until i input data into the cells in the results i would like it to display a blank cell now obviously we have a true and false value here

is there a way to edit this function so i can have 2 false values

so the function would look something like this but work

=IF('results '!G2=L2,F2,-E2,"")
or
=IF('results '!G2=L2,F2,-E2,if('results '!G2="",""))

these dont work but is there one that will

thanks

 

[njimack]

=IF('results '!G2,IF('results '!G2=L2,F2,-E2),"")

 

[coaster123]

thanks its a bit closer but that shows #value! i wanted the cell to display blank if at all possible

 

[njimack]

thanks its a bit closer but that shows #value! i wanted the cell to display blank if at all possible

=IF('results '!G2<>"",IF('results '!G2=L2,F2,-E2),"")

 

[coaster123]

yes yes yes yes yes yes the final peice in my puzzle thanks a million neil

 

[njimack]

No probs, thanks for the feedback.