If function
 

I need an IF function to look at cell b3 for an 'x', if the 'x' is true I
need it to return the number in b4, if the 'x' if false I need it to return
the same number in b4 in negative. Can anyone help?

If function
 

Does this work for you:

=IF(B3="X",B4,-B4)
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rlee1999" wrote in message
...
I need an IF function to look at cell b3 for an 'x', if the 'x' is true I
need it to return the number in b4, if the 'x' if false I need it to
return
the same number in b4 in negative. Can anyone help?

If function
 

Worked perfectly, Thank You!

"RagDyer" wrote:

Does this work for you:

=IF(B3="X",B4,-B4)
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rlee1999" wrote in message
...
I need an IF function to look at cell b3 for an 'x', if the 'x' is true I
need it to return the number in b4, if the 'x' if false I need it to
return
the same number in b4 in negative. Can anyone help?

If function
 

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rlee1999" wrote in message
...
Worked perfectly, Thank You!

"RagDyer" wrote:

Does this work for you:

=IF(B3="X",B4,-B4)
?
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"rlee1999" wrote in message
...
I need an IF function to look at cell b3 for an 'x', if the 'x' is true
I
need it to return the number in b4, if the 'x' if false I need it to
return
the same number in b4 in negative. Can anyone help?