See enclosed file sheet1.
I have a column (Calc4) where i want to format this column with two different formats based on the values in Calc1 column. For the different formats see enclosed file. Is this even possible?
See enclosed file sheet1.
I have a column (Calc4) where i want to format this column with two different formats based on the values in Calc1 column. For the different formats see enclosed file. Is this even possible?
Last edited by NBVC; 10-03-2011 at 01:32 PM.
Do you mean?
=IF(B2="",D2/100,IF(C2=0,0,D2/C2))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Its not very clear regarding what formats you need and how many. If we know we can help you decide if you need a conditional formatting or macro.
Hi
Format coloum E as General and give the formula
=IF(B2="",D2,TEXT(IF(OR(C2=0,ISERROR(D2/C2)),"",D2/C2),"#.#%"))
no not exactly. Sorry my explanation was not very good.
Basically, its this.
If value in colB is "blank" AND there is a value is colD of say 65............then i want column E to show "65 Qry".
If value in colB is not empty AND ColC and ColD are not empty then i want to show value of D/C as a percentage withone decimal place.
A little adjustment...
=IF(B2="",D2&" Qry",IF(C2=0,0,D2/C2))
that will work.
I feel kinda stupid.......i should have known that.........thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks