IF and ROUNDUP Formula Flase Statement Help

[CherryxDarling]

Just one more question about this formula:

=IF(E7>=65,ROUNDUP((E7/2)/65,0),"1")

Note: I'm using this formula in G7

Ok so when I use the above formula, I will always get a 1 in G7 even if there is no value in E7. How do I change it so that it will only display the 1 for the false statement when I input a value into E7? In other words, if there is no value in E7 I want G7 to also be blank. (I really hope that makes sense to someone.)

 

[Willmonbo]

try this

=IF(E7="","",IF(E7>=65,ROUNDUP((E7/2)/65,0),"1"))

 

[Scott Huish]

First you don't want to put quotes around your 1 that makes it text.
Second that can be simplified:

=IF(E7="","",IF(E7>65,ROUNDUP(E7/130,0),1))

 

[CherryxDarling]

try this

=IF(E7="","",IF(E7>=65,ROUNDUP((E7/2)/65,0),"1"))

Perfect. Thank you so much =)

 

[CherryxDarling]

First you don't want to put quotes around your 1 that makes it text.
Second that can be simplified:

=IF(E7="","",IF(E7>65,ROUNDUP(E7/130,0),1))

That works as well. I know it seems excessive to divide the # by 2 then divide by 65, but I'm working with building codes and they have a certain way they require the math to be done so I have to do it that way. Thanks for your help as well, this works perfect too.

 

[Willmonbo]

Yeah, I was assuming there was a reason for it, that's why I worked with the existing formula.