Stumped

[dgardnerman]

I want my formula in cell V5 to process only if there is an an "X" in cell B5..,I have a lot going on and I can't get the function to take...any help?

=IF(T5="","",IF(U5="","",CEILING((T5*U5/60),0.5)))

Here is a link to my dropbox with a snapshot:
https://www.dropbox.com/s/k0utk8hzfyvcfpc/Screen Shot 2018-10-27 at 2.35.53 PM.png?dl=0

 

[Fluff]

How about
=IF(AND(B5="X",T5<>"",U5<>""),CEILING((T5*U5/60),0.5),"")

 

[dgardnerman]

Awesome!!!!!!!! thanks Fluff, worked perfect!

 

[Fluff]

You're welcome

 

[dgardnerman]

I replaced all the other similar formulas with the previous and worked fine...now I have a monster I'm working on...here it is...same thing, I only want it to show when "X" is checked
=IFERROR(IF(G5="BOLT",E5,IF(I5="","",IF(G5="PLATE",(I5*K5/144*L5)*E5,IF(G5="GRATING",(I5*K5/12*L5)*E5,IF(G5="DECKING",(I5*K5/144*L5)*E5,(I5/12*L5)*E5))))),"")

https://www.dropbox.com/s/aslzn0qvcfgj8g3/Screen Shot 2018-10-27 at 3.11.36 PM.png?dl=0

 

[Fluff]

Try
=IFERROR(IF(B5<>"X","",IF(G5="BOLT",E5,IF(I5="","",IF(G5="PLATE",(I5*K5/144*L5)*E5,IF(G5="GRATING",(I5*K5/12*L5)*E5,IF(G5="DECKING",(I5*K5/144*L5)*E5,(I5/12*L5)*E5)))))),"")

 

[dgardnerman]

Perfect!!!! Thanks again...you nailed it.

 

[Fluff]

You're welcome

 

[dgardnerman]

So I decided to use a form control but the logic doesn't compute...I get a "FALSE" sum in the target cell, not sure why? can you take a look at this one...
=IFERROR(IF(C5="TRUE",IF(H5="BOLT",F5,IF(J5="","",IF(H5="PLATE",(J5*L5/144*M5)*F5,IF(H5="GRATING",(J5*L5/12*M5)*F5,IF(H5="DECKING",(J5*L5/144*M5)*F5,(J5/12*M5)*F5)))))),"")

you originally gave me IFERROR(IF(C5<>"X"....... I figure it's got to be something in the opening syntax that's throwing the result off, instead of the "X" I'm using form control and I added an extra column so it can read the the result of my radio button.

Here is a screen shot:
https://www.dropbox.com/s/kl5r7sx1agkjidy/Screen Shot 2018-10-28 at 10.09.52 AM.png?dl=0

 

[Fluff]

Try removing the quotes from the word TRUE