LinkBack URL
About LinkBacks
hello,
Is there any way to add a round up formula within the if function? the values im using has 2 different ave values
see attachment for the formula that i use
thanks
hello,
Is there any way to add a round up formula within the if function? the values im using has 2 different ave values
see attachment for the formula that i use
thanks
Last edited by jrortiz2; 10-01-2011 at 06:38 AM.
Hi,
What exactly you want to achieve? Can you explain which cells need adding and what result would you expect?
Cheers
greekboyuk
I can't tell what you are trying, perhaps the following will be helpful to you anyway.
To round up I have used the following logic -- example assumes I want to round up the result of a1/b1 for some reason.
The logic is: if rounding the number makes it smaller (so the subtraction isnegative), round it and add (1 in the case of rounding with 0 decimal places) -- if rounding does not, just round as per usual.
Please Login or Register to view this content.
If you were going to round to a different decimal place (say 1 place) you would use a slightly different formula....hopefully you can apply this logic.
the below is actually what i really want to appear in my formula that includes conditiona formatting.
-the lower values against last month should show number plus the arrow up
-the higher values against last month should show - number plus the arrow down
-no data means NR
-number 0 data should show "Stable"
-the same data against last month and current month should also show stable
as you can see in the attachment in the changes it shows 0 including the arrow right where is should have been 1 and the arrow up
Hope thats make sense. sorry for the confusing explanation
I have the following IF Function and need to be able to use the ROUND Function within this to round the figures to 0. can this be done?
IFERROR(IF(D14-E14=0,"Stable",D14-E14),IF(AND(E14="-",D14="-"),"NR",IF(D14="-","Gain","Dropped")))
attachment will show example
Thanks
why cant you just use the increase decimal button?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
You don't say exactly what or where you want it rounded but taking a guess based on the significant digits in C and D of your example
IFERROR(IF(D14-E14=0,"Stable",ROUND(D14,0)-ROUND(E14,0)),IF(AND(E14="-",D14="-"),"NR",IF(D14="-","Gain","Dropped")))
Is that what you wanted?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=IFERROR(FIXED(IF(C6-D6=0,"Stable",C6-D6),IF(AND(D6="-",C6="-"),"NR",IF(C6="-","Gain","Dropped"))),0)
opps sorry, mistake pls ignore
Last edited by Blake 7; 09-30-2011 at 06:06 PM.
IFERROR(IF(D14-E14=0,"Stable",Roundup(D14-E14,0)),IF(AND(E14="-",D14="-"),"NR",IF(D14="-","Gain","Dropped")))
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
thanks for the help guys it has been solve now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks