IF - need to insert a cell value
=IF(S8="Closed","T8","")
I need it to pull the value of T8 - not the actual letter/number T8 Thanks, Angela |
drop the quotes around T8
=IF(S8="Closed",T8,"") "AngelaG" wrote: =IF(S8="Closed","T8","") I need it to pull the value of T8 - not the actual letter/number T8 Thanks, Angela |
You're close - just drop the quotes around T8
=IF(S8="Closed",T8,"") "AngelaG" wrote: =IF(S8="Closed","T8","") I need it to pull the value of T8 - not the actual letter/number T8 Thanks, Angela |
THANKS!
"rahrah3a" wrote: drop the quotes around T8 =IF(S8="Closed",T8,"") "AngelaG" wrote: =IF(S8="Closed","T8","") I need it to pull the value of T8 - not the actual letter/number T8 Thanks, Angela |
Thanks!
"Duke Carey" wrote: You're close - just drop the quotes around T8 =IF(S8="Closed",T8,"") "AngelaG" wrote: =IF(S8="Closed","T8","") I need it to pull the value of T8 - not the actual letter/number T8 Thanks, Angela |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com