jeudi 26 mai 2016

ok, so another if or condition being met with feet, inches, formatting, and two cells with results

ok. so, i have a cell which displays in feet and inches from overall inch length cell is d32 but references p32 which is in overall inch formatt (12 feet equals 144) so the below formula makes the 144 inches say 12'

Cell D32:

=CONCATENATE((P32-MOD(P32,12))/12,"'-",ROUNDDOWN(MOD(P32,12),0),IF(MOD(P32,1),

Referenced cell is p32:

=(((G10*2)/B32)+2)

The +2 in the above p32 forumula is for gutter length. The way we figure gutters is there is a 2” waste for splicing two gutters together so we order gutters that are going to be spliced with an additional 2 inches of length. I want to have the formula in such a way as that if in cell B32 has 2 listed as the value or (1 gutter per short side) that is does not add the additional 2 inches that b32 does.

my conditional cell d32, if it has a value of 2, p32 does not add the additional 2 inches. Any value above 2 however must add the additional 2 inches.

workbook snap

Aucun commentaire:

Enregistrer un commentaire