I have a formula and then a label concatenated onto the end which works fine
but now I realize I have to format the numeric portion since it is working
with too many decimals. I know how to do this in access but not excel.
The formula is:
=IF(F10-H10>0,(F10-H10) &" LOSS",(H10-F10) & " PROFIT")
In msaccess, I would just add:
=IF(F10-H10>0,format((F10-H10),"fixed") &" LOSS",format((F10-H10),"Fixed") &
" PROFIT")
How do I do this in excel??
Bookmarks