Re: If statements in Excel
Re: If statements in Excel
- Subject: Re: If statements in Excel
- From: Kurt Klamp <email@hidden>
- Date: Wed, 28 Nov 2007 20:32:11 +0100
Maybe this helps:
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
if (get value of cell i of range ("F2:F" & z )) = Printed" then
set value of targetCell to {"OK"}
else
exit repeat
end if
end repeat
but why you don't fill the Range (column I) with a formula like '=IF
(F2="Printed";"OK";"")'
Kurt
_______________________________________________
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