Microsoft Works Spreadsheet Formula Question

Comments(7)

• 
  NC_Yank24th May, 2005

  There are slight differences in cost per square foot but it has more to do with the drywall price per square foot when dealing with 54 inch boards for a 9 foot wall.
  
  When estimating, it is quicker to do lineal foot calculations,........with the spreadsheet I havemade, I can estimate a house out in about 30 minutes........and be very accurate.
  
  NC_Yank

• 
  edmeyer24th May, 2005

  NC_Yank,
  
  See if your spreadsheet has an IF function. If it does, the likely format is IF(logical expression,value if true,value if false). You could probably do what you want with an expression in cell B18.
  
  =IF(B8=9,B7*E8,B7*E7)
  
  Any entry in B8 that is not 9 will give you B7*E7 but if you have only one alternative to 9, this should work.
  
  Regards,
  Ed

• 
  NC_Yank24th May, 2005

  There are 2 or possibly 3 alternatives other then 9.
  That would have worked if there were only one alternative.
  
  For each alternative will result in a different multiplier to be used.....
  
  Thanks Ed.
  
  
  Quote:
  On 2005-05-24 22:31, edmeyer wrote:
  NC_Yank,
  
  See if your spreadsheet has an IF function. If it does, the likely format is IF(logical expression,value if true,value if false). You could probably do what you want with an expression in cell B18.
  
  =IF(B8=9,B7*E8,B7*E7)
  
  Any entry in B8 that is not 9 will give you B7*E7 but if you have only one alternative to 9, this should work.
  
  Regards,
  Ed

• 
  edmeyer25th May, 2005

  NC_Yank,
  
  In Excel you can nest if functions. Suppose that in cell B18 you wanted the following depending on the entry that is in cell B8
  
  content of B8======want in B18
  7 ===============B7*E6
  8 ===============B7*E7
  9 ===============B7*E8
  
  You can do this with the following formula in cell B18
  
  
  =IF(B8=7,B7*E6,IF(B8=8,B7*E7,B7*E8))
  
  This idea should work if there are only a few alternatives. Does this help?
  
  Regards,
  Ed
  
  [ Edited by edmeyer on Date 05/25/2005 ][ Edited by edmeyer on Date 05/25/2005 ]

• 
  NC_Yank25th May, 2005

  Ed,
  
  Here is what I have now,
  
  B7 represents lineal foot of wall
  B8 represents height of wall.
  E7 represents wall cost for 8 ft. wall
  E8 represents wall cost for 9 ft. wall
  E9 represents wal cost for 10 ft wall.
  
  B18 represents the product of B7* (which ever wall height is used ~ E7, E8 or E9 )
  
  I tried the below formula but it comes back with "The function has the wrong number of arguments.
  
  =IF(B8=8,b7*e7),(IF(b8=9,b7*e8),IF(b8=10,b7*e9))
  
  NC_Yank

• 
  edmeyer25th May, 2005

  NC_Yank,
  
  The problem that you are having is because the IF function requires three arguments-- not two.
  
  The proper syntax for the IF statement is what I said in my previous post.
  
  IF(logical expression, value_if_true,value_if_false)
  
  Try this
  
  IF(B8=8,B7*E7,IF(B8=9,B7*E8,B7*E9))
  
  This will give B7*E7 if B8= 8, B7*E8 if B8 = 9 and B7*E9 if B8 is anything else.
  
  Regards,
  Ed

• 
  NC_Yank25th May, 2005

  Ed,
  
  Thanks a million.....that worked.
  
  NC_Yank