Re: Excel
Re: Excel
- Subject: Re: Excel
- From: Thomas Maffucci <email@hidden>
- Date: Mon, 09 Feb 2009 17:10:18 -0500
- Thread-topic: Excel
Deivy Marck Petrescu wrote:
>Actually, it is irrelevant what would be in T2:U6 in my examples.
>But, so it might be easy to clarify,
>LOOKUP(CELL, TABLE, VECTOR) means lookup where would cell be in >the table and
return the value from the vector
>I use that to assign grades.
>Say that 0-50 gets an F, 50-70 a D, 70-80 a C, 8 -90 a B and 90+ >an A,
>T2:T6 would be 0, 50, 70, 80, 90 U2 to U6 would be F,D,C,B,A
>Now if CELL is a value less than 50, the vector (U2:U6) returns F,
>less than 80 but more than 70, it returns B.
Thanks Deivy,
--set AC84 to (ASCII character (84))
--set AC85 to (ASCII character (85))
set frw to 2
set lrw to 6
set Fclm to "T"
set Lclm to "U"
--set part1 to "(RC[-1]," & (AC84 & "2:" & AC85 & "6") & "," & (AC85 & "2:"
& AC85 & "6)")
set part1 to "=Lookup" & "(R3," & Fclm & frw & ":" & Lclm & lrw & "," & Lclm
& frw & ":" & Lclm & lrw & ")"
--set part1 to "(R3," & (AC84 & "2:" & AC85 & "6") & "," & (AC85 & "2:" &
AC85 & "6)")
--set part1 to (part1 as string)
--return (part1)
tell application "Microsoft Excel" to set value of cell "S3" to part1
--->=Lookup(R3,T2:U6,U2:U6)
When I add your Table data,
The Formula above works fine under Excel 2008
_______________________________________________
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
- Follow-Ups:
- Re: Excel
- From: Deivy Marck Petrescu <email@hidden>