If text in columns return a value in another column

[Boyes]

Hi, I thought it would be reasonably straight forward but 'm struggling to put together a formula to populate the balance column depending on text being present in the columns. IE if column B has text the value returned is Column A, If C has text then column A becomes a positive and if both have text then it returns 0.

I'm using Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0)

 

[Fluff]

I'm using Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0)

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

How about

=IF(AND(B2<>"",C2<>""),0,IF(B2<>"",A2,-A2))

 

[Boyes]

How about

=IF(AND(B2<>"",C2<>""),0,IF(B2<>"",A2,-A2))

That works, thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.