CODEWITHSUNDEEP
excelgraph
Klaus
Klaus

Reputation: 41

Making Excel formula into a graph

I'm sure this is probably a really easy fix, but I'm stumped. I've got this formula:

=IF((E2-B14)>0,(B8*B7*B9)+(((E2-B14)*B13)*10%),(B9*B8*B7))

and I need to turn it into a graph. I want this formula to work out the increase in salary as E2 increases. The formula is in cell B2.

Let me know if you have any suggestions, any and all help enormously appreciated

Upvotes: 0

Views: 47

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34355

So put values from 1,000,000 to 15,000,000 in E2 to E16. Then if you have free space in column F, put your formula in F2 (with dollars to fix the values in column B) and copy down.

=IF((E2-B$14)>0,(B$8*B$7*B$9)+(((E2-B$14)*B$13)*10%),(B$9*B$8*B$7))

This will give you a sheet like this
226560 1000000 226560
2000000 226560
3000000 238560
4000000 268560
5000000 298560
1.18 6000000 328560
6000 7000000 358560
32 8000000 388560
9000000 418560
10000000 448560
11000000 478560
0.3 12000000 508560
2600000 13000000 538560
14000000 568560
15000000 598560

Then highlight the data in columns E and F (the x and y-values), go to insert chart and pick a scatter with lines. Your graph should show that the line is flat until the x-value goes above 2,600,000 and then rises linearly.

Upvotes: 1

Related Questions