Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Box Issue | Excel Discussion (Misc queries) | |||
Excel text box issue | Excel Discussion (Misc queries) | |||
Text Wrap Issue | New Users to Excel | |||
Text to columns issue | Excel Discussion (Misc queries) | |||
Issue with copying Text. | Excel Discussion (Misc queries) |