“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have created a sheet to calculate the cost of hair based on several factors: the length, the color and the ounces. I need to enter the required information on the HP Calculator sheet in the EXT PLUS PP HAIR section. I need these values to pull dollar amounts from the Ext Plus sheet and fill in the appropriate value on the HP Calculator sheet. I am stuck on the color value. I can't perfect the calculation to evaluate which group the selected color is in.

Solved by I. Q. in 15 mins

I need a formula to calculate cost based on 3 variables. The variables are chosen from a drop-down list on the HP Calculator sheet. On the Ext Plus sheet, you will see a table. The cost is based on the length, the color group, and the number of ounces. I can't get the formula right for the part that puts any color choice from sheet one into a color group on sheet two.

Solved by S. S. in 12 mins

I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)

Solved by O. E. in 12 mins

sir, how to find age calculator age on date formula

Solved by A. A. in 22 mins

I require Column H to start payments from a loan calculator built into spreadsheet, after Column G is completed payments from a separate loan calculator based on the payback period set, and for Column H to end after the payback period endsas set in the loan calculator. I have a file but it won't load.

Solved by T. L. in 20 mins