Hello,
Im have been trying to figure out this formula and I just cant get it.
I need to add an if to it so It can determin what text to display after displaying the number.
here is the formula im using to give me my number and the results need to show eather a negative number or a positive number which they do. I want to add something behind that number like:
-$123.00 you are negative
OR
$123.00 You are positve
my formula
Please Login or Register to view this content.
=if(E9-G12+J10>0,E9-G12+J10&" you are positive",E9-G12+J10&" you are negative"
Note: you're answer will now no longer be a number, it is text, and cannot be used (in its present for) in any other calcs
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok thank you I will have to just split the cell and have that formula behind the number one... Thanks!
Ok I got it to work with "Round" Now I cant format the cell t currency is there a way I can add a $ sign in front of result?
Please Login or Register to view this content.
Last edited by oxicottin; 11-15-2012 at 02:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks