issue with IF and text
 

I'm trying to get this formula in cell T62 to show "X" if W62 is blank or
less then 0 but add 3 to the value if "yes" is pulled down on a data
validtion chart in another cell

Here is what I have come up with but when W62 is greater then 0 and U62 is
"yes" it is not adding 3 more to the value displayed in T62

=IF(W620,SUM(V62:X62),"X"+IF(W620&U62="yes",3,0) )

It's more then likely something simple, I'll admit I am not very good at
excel I leave it for weeks and when I come back I have to "relearn" everything

Thanks!!

issue with IF and text
 

Try this...

Assuming W62 will not contain text.

=IF(W62<=0,"X",SUM(V62:X62,(U62="yes")*3)

--
Biff
Microsoft Excel MVP


"evilthorne" wrote in message
...
I'm trying to get this formula in cell T62 to show "X" if W62 is blank or
less then 0 but add 3 to the value if "yes" is pulled down on a data
validtion chart in another cell

Here is what I have come up with but when W62 is greater then 0 and U62 is
"yes" it is not adding 3 more to the value displayed in T62

=IF(W620,SUM(V62:X62),"X"+IF(W620&U62="yes",3,0) )

It's more then likely something simple, I'll admit I am not very good at
excel I leave it for weeks and when I come back I have to "relearn"
everything

Thanks!!

issue with IF and text
 

Thanks worked great!

"T. Valko" wrote:

Try this...

Assuming W62 will not contain text.

=IF(W62<=0,"X",SUM(V62:X62,(U62="yes")*3)

--
Biff
Microsoft Excel MVP


"evilthorne" wrote in message
...
I'm trying to get this formula in cell T62 to show "X" if W62 is blank or
less then 0 but add 3 to the value if "yes" is pulled down on a data
validtion chart in another cell

Here is what I have come up with but when W62 is greater then 0 and U62 is
"yes" it is not adding 3 more to the value displayed in T62

=IF(W620,SUM(V62:X62),"X"+IF(W620&U62="yes",3,0) )

It's more then likely something simple, I'll admit I am not very good at
excel I leave it for weeks and when I come back I have to "relearn"
everything

Thanks!!


.

issue with IF and text
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"evilthorne" wrote in message
...
Thanks worked great!

"T. Valko" wrote:

Try this...

Assuming W62 will not contain text.

=IF(W62<=0,"X",SUM(V62:X62,(U62="yes")*3)

--
Biff
Microsoft Excel MVP


"evilthorne" wrote in message
...
I'm trying to get this formula in cell T62 to show "X" if W62 is blank
or
less then 0 but add 3 to the value if "yes" is pulled down on a data
validtion chart in another cell

Here is what I have come up with but when W62 is greater then 0 and U62
is
"yes" it is not adding 3 more to the value displayed in T62

=IF(W620,SUM(V62:X62),"X"+IF(W620&U62="yes",3,0) )

It's more then likely something simple, I'll admit I am not very good
at
excel I leave it for weeks and when I come back I have to "relearn"
everything

Thanks!!


.