Thread
:
Custom Format Cell
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
Custom Format Cell
Woops! Replied to the wrong post - sorry.
--
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Sandy Mann" wrote in message
...
Try:
=SUMIF(H1:H12,"<"&TODAY()-60,I1:I12)
Adjust to suit your own ranges.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"nastech" wrote in message
...
Hi, I am looking for way to custom format cell to read 1.511B or
1.511M
as: 1B 1M (also would like example for 1.5B or 1.5M). thanks
already have cell formatted as Number, works with other work column with
e.g.:
=IF(OR(CE138=0,BZ138={0,"n/a"}),"",(LEFT(BZ138,LEN(BZ138)-1)*IF(RIGHT(BZ138,1)="b",10^9,1)/CE138*$BV$4))
Just looking for custom formatting such as: ##0.0*
Reply With Quote