Use of cell value in formula

M

mrmcd104

New Member
Joined
Jun 4, 2015
Messages
1
In column A i have values and in column B I have either < or >. I'd like to create a formula that says =If(A1>0,1,0) but I'd like to use the value in column b to determine if it's greater than or less than. How can I do this?

Thanks!
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
You would have to use the INDIRECT() argument

not sure if this is correct but something like
Code: 
 =IF(A1(INDIRECT("$B1"))0,1,0)

Like I said don't think that is the exact code but using the indirect() argument will give you the other cells value im pretty sure
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
help with If and formula
Replies
9
Views
646
Samgraphics
S
brasqo
  • Solved
Not sure what function to use - INDEX/MATCH, VLOOKUP?
Replies
3
Views
478
jtakw
jtakw
N
  • Solved
Get index/position of value in dynamic range
Replies
6
Views
2K
Peter_SSs
Peter_SSs
I
  • Solved
Help with correct formula please
Replies
4
Views
353
nageswararao
nageswararao
F
  • Solved
Sum values in non-contiguous cells, but only where both values are greater than 0.
Replies
2
Views
2K
Fletcher57
F

Forum statistics

Threads
1,203,198
Messages
6,054,073
Members
444,701
Latest member
PTDykman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top