Hi I am using this formula to return a value and a label
=IF(NewGP-OldGP=0,"No Change",IF(NewGP-OldGP>0,NewGP-OldGP&" Increase",IF(NewGP-OldGP<0,NewGP-OldGP&" Decrease")))
value = NewGP-OldGP and where the formula is bolded I only need the standard 2 decimal format. I've tried, but failed.
thank you for your time and help.
=IF(NewGP-OldGP=0,"No Change",IF(NewGP-OldGP>0,NewGP-OldGP&" Increase",IF(NewGP-OldGP<0,NewGP-OldGP&" Decrease")))
value = NewGP-OldGP and where the formula is bolded I only need the standard 2 decimal format. I've tried, but failed.
thank you for your time and help.