need help!!!

[Lone Star]

Can anyone tell me how to write this formula in Excel?
If D7 is 3 use this formula=SUM(D8*180)+(D9*30)
If D7 is 5 use this formula=SUM(D8*310)+(D9*30)

And what is the name of the formula?

Thanks

 

[Domenic]

Try...

=IF(D7=3,(D8*180)+(D9*30),IF(D7=5,(D8*310)+(D9*30),""))

Hope this helps!

 

[Aladin Akyurek]

Insert a new sheet and name it Admin.

In A2 enter a name that is descriptive of 30, say, Thirty.
In B2 enter: 30

Name B2 Thirty via the Name Box on the Formula Bar.

In A4 enter: 3
In A5 enter: 5
In B4 enter: 180
In B5 enter: 310

Select A4:B5 and name the selection ConstantTable via the Name Box.

Now invoke...

=D8*VLOOKUP(D7,ConstantTable,2,0)+D9*Thirty

 

[respree]

You don't say what you want it to do if D7 is neither 3 or 5.

Assuming you want to display a blank (" ", in this formula), it's:

=IF(D7=3,SUM((+D8*180)+(+D9*30)),IF(D7=5,SUM((+D8*310)+(+D9*30)),""))

Replace the "" for 'whatever you want it to do if neither of the two conditions are met.

 

[Lone Star]

I think it worked...thanks a bunch what is this called?

 

[respree]

The "if" formula.

 

[Lone Star]

thanks it looks as if all is working well.