If function for positive and negative numbers

[reesjonesrb]

Hello,

I am trying to make a formula to look at the previous column, if it's a positive number it is to do one scenario, and if it's negative it needs to carry out another formula.

So in words - If A1 is less than 0, then answer is B1, if A1 is more than 0 then answer is (B1+(D1-C1))

Hope that makes some sense and look forward to your help. Thanks,
Barns

 

[Eric W]

Welcome to the forum.

Try:

=IF(A1<0,B1,B1+D1-C1)

Little puzzled though. You say you're looking at the previous column? You want to put this in B1? That would cause circular references.

 

[SQUIDD]

Does this work for you

=if(a1<0,b1,b1+(d1-c1))

dave

 

[reesjonesrb]

Excellent, worked a treat thanks. I'm sure I'll be on here again over the next couple of days, writing a solar PV design spreadsheet and have lots of learning to do! Thanks for the prompt help!

 

[FDibbins]

Just to throw another 1 out there...
=B1+IF(A1<0,0,D1-C1)