Link to home
Start Free TrialLog in
Avatar of davie jonea
davie joneaFlag for United Kingdom of Great Britain and Northern Ireland

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. 
ASKER CERTIFIED SOLUTION
Avatar of Sam Jacobs
Sam Jacobs

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial