How to display $ sign in front of: 50 under, 50 over
And I forgot the $'s!
$0.00" Over";[Red]$0.00" Under";"at estimate";@
or
$0.00" Over";$0.00" Under";"at estimate";@
You don't have to use the cents portion, either.
st wrote:
"misona1" сообщил/сообщила в новостях следующее: ...
=IF(SUM(B39)-SUM(C39)=0," at
estimate",IF(SUM(B39)-SUM(C39)0,(SUM(B39)-SUM(C39))& " over",
ABS(SUM(B39)-SUM(C39))& " under"))
=IF(SUM(B39)-SUM(C39)=0," at
estimate",IF(SUM(B39)-SUM(C39)0, "$"& (SUM(B39)-SUM(C39))& " over",
"$"& ABS(SUM(B39)-SUM(C39))& " under"))
--
Dave Peterson
|