Capping an IF function

[DJMini]

Hi all,

I am trying to cap this formula to 15 =IF(B2=1,(C2*12)/1000," ")
B column contains number of stems. C contains stem diameter. H contains =IF(B2=1,3.141*(I2^2)," ") which calculates the root protection area and I column contains =IF(B2=1,(C2*12)/1000," ")

For example currently:
Tree number: 1
No of stems: 1
Stem diameter: 1500
RPA for stem (m2): 1018
Radius (m): 18

and i need it to be:
Tree number: 1
No of stems: 1
Stem diameter: 1500
RPA for stem (m2): 707 (this is affected by the radius)
Radius (m): 15

Can anyone help?

Thanks
Dan

 

[DJMini]

Oh and if there is nothing in a certain cell in column A for example A2 then the rest of row 2 is blank.

 

[jtakw]

Hi,

Not sure, may be you mean this?

=IF(B2=1,MIN((C2*12)/1000,15),"")

Also notice the part in Red in the formula, you had a SPACE rather than BLANK, unless a space is what you wanted.

 

[DJMini]

Yes that's it! Thank you.
Thank you for highlighting the space, it wasn't intentional.

 

[jtakw]

You're welcome, welcome to the forum.