Can an IF formula add a cell value to message?

[albertc30]

Hi all.
</SPAN>
I am totally in uncharted waters here and don’t even know if this is possible.</SPAN>

What I am trying to do is to add a cell value to a sentence that is returned in an IF statement.</SPAN>

For example cell A1=9%.
</SPAN>
On cell A2 I have this formula;</SPAN>

=IF(A1>0%,”TOO MUCH WATER HAS BEEN USED”,”NOT ENOUGH WATER USED”)</SPAN>

This works fine.
</SPAN>
What I want to do if possible is to change the “too much water has been used” to 9% more water has been used”.
</SPAN>
Can this be done?</SPAN>

Any help is, as always, much appreciated.</SPAN>

Regards</SPAN>
Albert</SPAN>

 

[Andrew Poulsom]

Like this?

=IF(A1>0%,TEXT(A1,"0%")&" MORE WATER HAS BEEN USED","NOT ENOUGH WATER USED")

 

[VoG]

Try like this

=IF(A1>0%,TEXT(A1,"0.0%")&" TOO MUCH WATER HAS BEEN USED",TEXT(A1,"0.0%")&" TOO LITTLE WATER USED")

 

[albertc30]

Andrew and VoG;

It's not for no reasson at all you guys have got well over 60.000 posts.

You know your excel. My hat to that.

Many many thanks guys.

80% of my spreadsheets is thanks to you all. I couldn't do it without you guys.

This forum has made my life so much easier. I love excel. So far there is nothing that can't be done in this lovely application.

Will I ever be as good as you guys? Remains to be seen. I can only hope that one day, in years to come, I can give back to the forum as much as the forum has given me.

Have a nice Easter weekend to all.

Regards,
Albert