Help with return values on IF/THEN

C

Chrissy

I am trying to write an if then statement, where if the amount in a cell is
greater than zero it will return the value in another cell.

IF (a3>0, then "A5") can't link to the A5 cell and A5 is returned.

If (a3>0, then C3=A5) won't work....getting an error.

Thanks for your help...
 

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

How to create a formula with multiple (IF) conditions 3
Return latest value from data range 4
Excel formula, sum the value cell and if empty cell left blank 0
if statement 2
Mandatory and optional formula 5
value based on count (equation question) 2
Conditional Formating Question 5
Formula to return a formula 1

Top