excel formula

[fsuchef45]

I need an excel formula to multiply 3 dif problems for the sum to be entered into one cell. Example: lets say A1 is a constant, then if D6 needs to=A1*A2, but if nothing is entered into A2 then D6 needs to =A1* A5, but if neither A2 or A5 have any value except 0 then D6 needs to = A1*A10. Does anyone have a clue or an idea on a formula Thanks

[kempie]

This should work for D6

=IF(AND(A5=0,A2=0),A1*A10,IF(A2=0,A1*A5,A1*A2))

[fsuchef45]

kempie, Put the formula in and still have no sum in the answer cell. thanks fo working on this. I just cant figure this one out.

[kempie]

What values do you have for A1, A2, A5 and A10?

[stevie21]

Just use lots of nested IF statements.

[fsuchef45]

A1=6 is the variable constant, A2=2 A5=0 A10=0 A10 is the answer cell this needs to = A2,A5,A7*A! at any given time as A1 changes. thia is a recipe costing spreadsheet

[fsuchef45]

***UPDATE*** My bad !!! D6 is the answer cell A1=6 is the variable constant, A2=2 A5=0 A10=0 D6 is the answer cell this needs to = A2,A5,A7*A! at any given time as A1 changes. thia is a recipe costing spreadsheet

[fsuchef45]

***UPDATE*** My bad !!! D6 is the answer cell A1=6 is the variable constant, A2=2 A5=0 A10=0 D6 is the answer cell this needs to = A2,A5,A10* A1 at any given time as A1 changes. thia is a recipe costing spreadsheet

[fsuchef45]

sorry iys been a long day already

[kempie]

Using your sample figures with my formula in D6 gives a result of 12.

Inputting 4 into A5 does not alter the result until A2 is set to zero, which then gives a result of 24 in D6.

Is this what you are after?

[fsuchef45]

yes, but it is not computing on my end, the actual cells are
B3=6, B9=2,D9=0,F9=0 and H9 is the answer thanks for being so nice and persistant. im new to excel

[fsuchef45]

do I need to format the cell or cells to numbers or general

[fsuchef45]

Kempo, IT WORKED Thank you so much I maed the error in the input you were rite the first time. you are the best thanks again. I may need more help from time to time.

[fsuchef45]

sorry kempie

[kempie]

I was starting to get a bit worried ;-)

Glad to be of help.

[fsuchef45]

kempie, dude youstill on

[fsuchef45]

Ok new problem...................... P9is the answer cell.......=P11/B3.............P11 =a sum of $4.113 and B3= a sum of 10 with P9 having a end result of $0.4113 seeing how this is money costing I need P9 to round up to become $0.42 thus rounding up to the next cent

[fsuchef45]

Hey dont worry about this one I did fig it out it was =ROUNDUP(P11/B3,2)

Thanks for all the help
by the way where do you live? Im in Cumming Georgia, USA