Thread
:
If statment help
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
xlmate
external usenet poster
Posts: 144
If statment help
glad that you've found a solution.
--
Hope this is helpful
Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.
Thank You
cheers, francis
"Joe Wildman" wrote:
Never mind I linked the cell A33 with the code and used cell c4 as the input
line, it works nice!
"Joe Wildman" wrote:
Hello everyone, I put this code into A10, I need A10 (as it will populate as
"(Open)to also populate into cell C4 but I need to be able to add more text
into cell C4 as (open) will be the end statment, any ideas?
=IF(OR(C1="Open",C1="N/A",),"(Open)",IF(C1="Closed","(Closed)",""))
Reply With Quote
xlmate
View Public Profile
Find all posts by xlmate