concatenate? For Formula

[John Caines]

Hello All.
I have a formula that is working that is the following;

=IF(LEN($O$24)=0,"",(AVERAGE($O$24:$O$274)))

this just gives me the average £ amount for any cells entered in that range,,, great.
What I'm trying to do is create a formula that rather than just show a resulting amount;
(For Example),,,£124.50,,,, it will show,,,

"Daily Avg. £124.50" (Without Brackets/parentheses)

I'm trying formulas like;

=IF(LEN($O$24)=0,"","Daily Avg",(AVERAGE($O$24:$O$274)))

It doesn't work,,, not sure how to do it,,,
could someone please show me the error of my ways,,, I can't be too far off,,,

I hope someone can help me.

Many Thanks
johnCaines

 

[Aladin Akyurek]

Try...

=IF(COUNT($O$24:$O$274),"Daily Avg: "&AVERAGE($O$24:$O$274),"")

 

[VoG]

Hi John. Try

=IF(LEN($O$24)=0,"","Daily Avg "&DOLLAR(AVERAGE($O$24:$O$274),2))

 

[jeffreybrown]

Could you maybe also just use a custom format?

Ctrl + 1
Number Tab
Category: Custom
Type: "Daily Avg." [$£-809]#,##0.00

 

[jasonb75]

Maybe

=IF(N($O$24:$O$274),"Daily average "&AVERAGE($O$24:$O$274),"")

 

[John Caines]

Many thanks for both your replies!

I did try another that was almost,,,

=IF(LEN($O$24)=0,"","Daily Avg",&(AVERAGE($O$24:$O$274)))

Kind of worked but the amount returned was like £124.5012,,,,not what I wanted,, and I looked at formatting the cell to currency,,, to just 2 decimal places,, but it wouldn't

Many thanks Aladin Akyurek,,, for your formula,,, but this also has the same problem with the 4 digits,,,,

VOG,, your formula,,, working perfectly!
The & DOLLAR bit,,,, this seems to get over my problem.... Excellent..

Many thanks to you both

A very grateful
John Caines

 

[Aladin Akyurek]

Many thanks for both your replies!

I did try another that was almost,,,

=IF(LEN($O$24)=0,"","Daily Avg",&(AVERAGE($O$24:$O$274)))

Kind of worked but the amount returned was like £124.5012,,,,not what I wanted,, and I looked at formatting the cell to currency,,, to just 2 decimal places,, but it wouldn't

Many thanks Aladin Akyurek,,, for your formula,,, but this also has the same problem with the 4 digits,,,,

VOG,, your formula,,, working perfectly!
The & DOLLAR bit,,,, this seems to get over my problem.... Excellent..

Many thanks to you both

A very grateful
John Caines

You should replace the LEN bit with the COUNT bit though...