Hello People,
Hope everyone is well.
How do i do the following:
I have a nested IF formula and depending on which value it shows it will id be a standard number or a currency
Formula:When the second IF is true the cell needs to desiplay a £ plus the value.
Please Login or Register to view this content.
Any help would be great
Thanks
Paul
Hi,
Conditional number formatting cannot be handled by conditional formatting ...
It requires some coding in an event macro ...
Which cell or cells carry this particular formula ? ...
HTH
Carim
It depends if you need to use the result in another calculation, if not you could use something like this, maybe?
=IF(A1<10,A1,IF(A1=10,"£ "&A1,0))
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
My choice would probably be to use the TEXT() function;
Note however that the resultant cell will be of TEXT type rather than NUMBER type,Please Login or Register to view this content.
which could be a problem if you want to use the result in future calculations.
The format string is the same as that used in the cell custom formats (if you want to use something other than the "general" format).
Mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks