davie jonea

asked on

# How do I get a formula to change the way it shows

I have the following formula and it shows in the cell as a NEGATIVE FIGURE.

=IF(M27<=0, M27,"")

Is there any way I can change it so it calculates as formula above but it shows it as a POSITIVE figure. So in the cell if M27 is a negative figure I need it displayed in the cell the formula is in to be positive as its on the credit side of a sheet.

=IF(M27<=0, M27,"")

Is there any way I can change it so it calculates as formula above but it shows it as a POSITIVE figure. So in the cell if M27 is a negative figure I need it displayed in the cell the formula is in to be positive as its on the credit side of a sheet.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.