IF function help

[flash33181]

I have a large spreadsheet I'm working on and here's what I want to do:

IF a particular cell has "x" value in it, then I want to multiply a corresponding cell with a pre-filled in dollar value by .45 and place that calculation in a different cell.

Example:

If cell A1="636" then multiply the value of cell B1 by .45 and place in cell C1.

Does that make sense what I'm asking? I can't figure out how to do it other than manually and I have hundreds of cells to do this on.

Thanks in advance.

 

[Dr Dee]

Hi,
I don't get the chance to help too much so you're very fortunate
Hoping I understand what you want, try

=SUMIF($A2:$A20,">0",B2:B20) in Cell B21 then copy/paste across C21, D21, E21.

Hope this helps,

Den

 

[LadyBills02]

Thank you! Had the wrong Column, but I got it!!!!