/biz/ - Business & Finance » Thread #936150

[11 / 5 / ?]

564KiB, 3264x904, image.jpg

Anonymous ID:FIpMcSbs Sat 24 Oct 2015 19:18:43 No.936150 View Reply Report Delete

Yo can anyone help me with my Excel homework I have no idea what to do here, my professor said to use VLookup....but how?

Anonymous

View Same Google ImgOps iqdb SauceNAO image.jpg, 3MiB, 3264x1995

Anonymous ID:FIpMcSbs Sat 24 Oct 2015 19:19:48 No.936151 Report Delete

Quoted By: >>936180

This is the worksheet

Anonymous

Anonymous ID:ssgbr88O Sat 24 Oct 2015 20:01:04 No.936180 Report Delete

Quoted By:

>>936151
>he took a photo of the screen

Anonymous

Anonymous ID:XXuT9nPd Sat 24 Oct 2015 20:05:04 No.936182 Report Delete

Quoted By:

http://www.exceltrick.com/formulas_macros/excel-if-statement/

use a little imagination

Anonymous

View Same Google ImgOps iqdb SauceNAO well well well.jpg, 28KiB, 525x289

Anonymous ID:XXuT9nPd Sat 24 Oct 2015 20:13:45 No.936189 Report Delete

Quoted By: >>936195

>>936150
what will you give me?

Anonymous

View Same Google ImgOps iqdb SauceNAO woops.jpg, 26KiB, 529x299

Anonymous ID:XXuT9nPd Sat 24 Oct 2015 20:22:30 No.936195 Report Delete

Quoted By:

>>936189
woops, missed a decimal

Anonymous

Anonymous ID:oKqdDOyL Sat 24 Oct 2015 20:26:05 No.936200 Report Delete

Quoted By:

Hahaha Jesus

Anonymous

View Same Google ImgOps iqdb SauceNAO hue.jpg, 72KiB, 821x569

Anonymous ID:oKqdDOyL Sat 24 Oct 2015 21:00:17 No.936222 Report Delete

Quoted By:

there you go bud

Anonymous

Anonymous ID:pMEAH5xA Sun 25 Oct 2015 02:54:03 No.936465 Report Delete

Quoted By: >>936475

>>936150
Why bother with a Vlookup? Simple If statement will do. =IF(price <= 10, price * 10, 100+(price-10)*5), done

Anonymous

Anonymous ID:1drDANtL Sun 25 Oct 2015 03:23:23 No.936475 Report Delete

Quoted By: >>936545

>>936465
>magic number

Tsk Tsk

Anonymous

Anonymous ID:pMEAH5xA Sun 25 Oct 2015 07:38:18 No.936545 Report Delete

Quoted By:

>>936475
I simplified it because op seems retarded enough as it is. Technically the threshold and points given would be variables defined as inputs at some other part of the sheet.

Subject

Name

E-mail

Password

Capcode	All Only User Posts Only Verified Posts Only Moderator Posts Only Manager Posts Only Admin Posts Only Developer Posts Only Founder Posts
Show Posts	All Only With Images Only Without Images Only Spoiler Images Only Non-Spoiler Images
Deleted Posts	All Only Deleted Posts Only Non-Deleted Posts
Ghost Posts	All Only Ghost Posts Only Non-Ghost Posts
Post Type	All Only Sticky Threads Only Opening Posts Only Reply Posts
Results	All Grouped By Threads
Order	Latest Posts First Oldest Posts First

On these boards

Your latest searches