Seems like it should be so easy. if(b2>0,a2=b2+1000,0) Except it doesn’t work. How can I do it?
You are entering the formula into A2 so you don’t add the A2=. You need to start all formulas with =. The formula then is =IF(B2>0;B2+1000;0) which will show a zero if B2 is less than 0; if you want the cell to be blank if B2 is less than zero then replace the 0 with two double quotes=IF(B2>0;B2+1000;""). Cheers, Al
Wonderful explanation. Thank you.
The formula
=if(b2>0;b2+1000;0)
placed in A2 will do what you want.
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.
In case you need clarification, edit your question (don’t use an answer) or comment the relevant answer.
Thank you.