If statements in Excel
If statements in Excel
- Subject: If statements in Excel
- From: "Justin Laden" <email@hidden>
- Date: Wed, 28 Nov 2007 14:05:45 -0500
I'm having difficulty with if statements in Excel; I'm trying to go through every cell in a range (one column in my table), and based on the value of a cell, I want to fill another cell in another column with a value. For some reason, my code for this action does nothing. Here's what I have so far.
repeat with
i from 1 to (count
cells of range ("F2:F" & z
))
set
targetCell to (cell i of range
("I2:I" & z))
if
value of cell ("F" & i) = "Printed" then
set
value of targetCell to {"OK"}
else
exit
repeat
end
if
end
repeat
_______________________________________________
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