Negative value to make

[jack999]

I am using this (=J4+D56-K4-D57) formula and getting negative value, but I want this negative value to make credit


suppose if the answer is -59700.00 I want the value as 59700.00 credit

if the result is 59700.00 then 59700.00 debit

can any one give a solution.

 

[SirJB7]

Hi, jack999!

Apply this custom format:

#0.00" debit";#0.00" credit"

Regards!

 

[jack999]

Thanks, Can we use IF statement with formula to get right answer instead of custom format.


regards

 

[SirJB7]

Hi, jack999!

Yes, you can use an IF statement but that'd be in another cell:

=TEXT(A1,"#0,00")&IF(A1>0," debit"," credit")

where A1 is the original cell.

Regards!

 

[jack999]

Can we use if statement on this =J4+D56-K4-D57 formula for getting the same result on the same cell.


regards

 

[SirJB7]

Hi, jack999!

Just change the two occurrences of A1 in the previous formula by J4+D56-K4-d57.

Regards!

 

[jack999]

I tried to change but not getting correct answer

 

[Colin Legg]

Did you try it like this?

[pre]

=TEXT(J4+D56-K4-D57,"0.00 ")&IF((J4+D56-K4-D57)>0,"debit","credit")

[/pre]