if one cell were to equal __ what would the value in another cell

U

uldk

Suppose

A1 = 5
B1 = 10
C1 = a1+b1

Can you put a formula in a cell that would say that if a1 were to be 10 and
have it display then what would the value in c1 be.


I need this for something much more complex than this but this is the
general idea.
 
E

Eduardo

Hi,
please could you provide with more information but an starts

=if(a1=10,your formula)
 
B

Bernard Liengme

Not too clear:
="If A1 = 10 then A1+B1 would be " & Text(10+B1,"#.00")
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Referencing the values of multiple cells in conditinal formatting. 0
Copying a cell value to another sheet by using If statement 1
Help with IF Function for times. 5
Show a cell's formula in text format in a linked cell 2
Find partial text and retrun value in corresponding column 3
Multiple Criteria, One Answer 1

Top