srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
I am trying to use formatted value withing this formula.
=A39&" "&MAX(B6:B35)
Max function brings the value with 12 decimals, where and how shoud I put currency format somthing like, "$#,##0.00". (if this is correct)?.
=A39 has the following formula.
=IF(A3>0,"Deduct from","Add to")
Thanks
=A39&" "&MAX(B6:B35)
Max function brings the value with 12 decimals, where and how shoud I put currency format somthing like, "$#,##0.00". (if this is correct)?.
=A39 has the following formula.
=IF(A3>0,"Deduct from","Add to")
Thanks