d2jsp
d2jsp Forums > Off-Topic > Programmer's Haven > Question About Equations On Google Spreadsheets
Add Reply New Topic New Poll
pwb3
#1 Mar 5 2021 02:35pm
Group: Member
Posts: 48,750
Joined: Feb 15 2006
Gold: 20,518.56
Hello,

I would like to learn how to make an equation that will automatically pull numbers from a column based on what number I put in one cell.

What equation would one use for that kind of function?

I have numbers listed in Columns A, B and C, and a function Y = (([Cell B1]*4 + [Cell C1])*0.02)/4

And in Column A I have every integer ranging from 60 to 100. In Columns B and C I have numbers.

So my goal here is to make a function that, if I enter 60 in this cell, the function will match that number in Column A and pull results from B and C in same row to put in that function.

How do I do that? IF/THEN or MATCH or...? I'm not really sure how.
Go Back To Programmer's Haven Topic List
Add Reply New Topic New Poll