Problem with IF Function not giving right results.

[CKANE86]

First time here, so I'll try to explain best I can.

This is the formula I'm using: =UPPER(INDIRECT(IF("Sheet2!D"&ROUNDUP((ROW()-1)/47+2,1)=0,"Private Pay","Sheet2!D"&ROUNDUP((ROW()-1)/47+2,1))))

My problem is I can't seem to figure out how to get this to give me a True result, no matter my efforts I keep getting False. The cell that it's referring to is blank, I've made sure of this. So either the =0 is wrong for a blank cell or something else is wrong. I'm trying to make a formula that I can copy and paste every 47 rows and I've succeeded in doing so, if I put values in the Reference cell it will show appropriately. I just can't get the True value right.

[Jonmo1]

I think you have your Indirect and IF reversed (the Indirect should be inside the IF)
And you need the indirect twice..

Try

=UPPER(IF(INDIRECT("Sheet2!D"&ROUNDUP((ROW()-1)/47+2,1))=0,"Private Pay",INDIRECT("Sheet2!D"&ROUNDUP((ROW()-1)/47+2,1))))

[CKANE86]

Thank you Jonmo1, that was exactly it. I've only been self teaching myself for a week now, so I knew I had to have something out of order or missing a small part. Thank you so much for your quick response!

[Jonmo1]

You're welcome.