Here are some problems that our users have asked and received explanations on
I am trying to get the percent variance in cell c5 to not show the negative
Solved by I. J. in 24 mins
I know how to calculate variance percentage in excel. But when the percentage is a negative number I want the value to display as "Missing Data not the negative number and I want to make a pivot chart by PM to summarize the data.. I can not provide the file due to company policy via this link
Solved by D. A. in 19 mins
negative or zero values cannot be plotted correctly on log charts.Only positive values can be interpreted on a logarithmic scale.
Solved by O. A. in 23 mins
Hi i need the custom format for display of numbers in lakhs with two decimals and negative numbers in brackets. for eg -123456789.00 to be displayed as (1,234.57). Can this be provided
Solved by I. J. in 13 mins
I am trying to take cell BE7 and sum BD7-BD6, if number becomes negative I need it to just match BD7, is there a way this can be done? thank you.