Re: If statements in Excel
Re: If statements in Excel
- Subject: Re: If statements in Excel
- From: "Justin Laden" <email@hidden>
- Date: Fri, 30 Nov 2007 15:57:16 -0500
Well, I appreciate your help, Stan and Paul, but I'm still having trouble.
I have given up--for the moment--on trying to walk through an Excel
column, parse each cell, then use if statements to alter the data of
another cell in another column.
Earlier, I think Stan suggested that I tackle my problem through Lists
instead of Excel columns.
I can take care of writing a list back into an Excel column, but the
difficulty for me is walking through the list, and based on each item,
performing an action--here with an if statement--truncating part of a
string in an item, and then setting the truncated part of the string
as the corresponding item in another list. The second (to be
populated list) is empty originally, but based on the control
statements in the first list, I want it to be populated with a string,
or no data (maybe empty strings...).
I'll worry about my truncation handler or method later.
I've tried but no luck with the walk though, and control statement
challenge of working with lists--here is what I came up with:
(*repeat with i from 1 to (numItems)
if item i of pageSizeRange = "1" then
set item i of priceRange to "true"
end if
end repeat*)
I greatly appreciate all your help so far!
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden