Trying to join to If's and an And!

**DSL1970** · 06-27-2012, 06:54 PM

I am working on a calculation next to a pivot table. The first If statement Shows the 0.00% running off the sheet when pivot is collapsed and the second does give the calc of c12/$e12 if there is a value in C12. I was using the A column for the names in the pivot, so it would not run past the last line.

All I want is to input 0.00% if there is not a value in column C and if there is calculate C/E, without it running off the page when the pivot is collapsed.

=IF(AND(ISTEXT(A12),C12=""),"0.00%",(C12/$E12))
=IF(AND(ISTEXT(A12),C12=""), "0.00%","")

Any help wopld be appreciated!

Thanks.

**FDibbins** · 06-27-2012, 07:36 PM

if you want to use a formula outside a PT, and dont want it to show if the PT shortens, use something like

=if(C12="","",c12/$e121)

let me know how this works for you, and maybe upload a sample if it doesnt fix what you need

**DSL1970** · 06-27-2012, 07:53 PM

Thanks FDibbins, but I do not think that this will come out with the "0.00%" for those cells that do not contain any data. Or am I missing something?

**FDibbins** · 06-27-2012, 08:02 PM

no it wont, but if your PT shortens, wouldnt you want to show nothing rather a bunch of 0.00%'s just hanging in the middle of nowhere, with no data related to it?

**DSL1970** · 06-27-2012, 08:17 PM

That is what my VP wants to see!!!

**FDibbins** · 06-27-2012, 11:29 PM

so the VP wants to see a bunch of "hanging" numbers with no data attached to them?

change it to =if(C12="","0.00%",c12/$e121)

Trying to join to If's and an And!

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Trying to join to If's and an And!

Re: Trying to join to If's and an And!

Re: Trying to join to If's and an And!

Re: Trying to join to If's and an And!

Re: Trying to join to If's and an And!

Re: Trying to join to If's and an And!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions