multiply a certain value to another from( other field) remain blank if no entry made

[tushmen36]

I would like to have a formula run the entire length of a column, but appear blank until info is entered. What I want is to have a formula that I can enter 1 number into this field and it does a calculation using this number and a number from another field. i.e I enter .25 in this field and it then multiplies that times 600 which is from another field. sorry if this is confusing and thanks for any help.

[vlady]

something like ??

=if(A1="","",A1*600)

or change 600 to the ref cell

=if(A1="","",A1*B1)

=if(any condition,condition is true,condition is false)

[tushmen36]

Capture.JPG

I hope you can see this picture I attached...

[vlady]

=if(c2="","",c2*a2)

what would you do with the rate column?

[tushmen36]

the rate will just be a fixed price. i'm having some difficulty with your suggestions, but they are appreciated. I think I may have away around making this so difficult. Since the number I would want to enter into C2 would really only change every week, is there a formula I could use that would take the value of each separate cell in the A column and multiply it by the single weekly value that I could put in a cell by itself, say E2 in my picture. so the formula would change =if(a2="","",a2*e2) to =if(a3="","",a3*e2) to =if(a4="","",a4*e2) etc. is that possible, to keep one value the same but change others? i'm trying but it keeps changing the "e2" instead of leaving that constant. thanks again for your help

[vlady]

using dollar sign.

from E2 when fill down changes 2 to 3,4,5,6... when fill across E changes to F,G,H,.... so by using

dollar sign

$E2 -> the E doesn't change but the 2 changes to 3,4,5..

E$2 -> the E changes when fill across but the 2 remains constant even drag down

$E$2 -> so this will not change notice the position of the dollar sign.

you formula would then be

=if(a3="","",a3*$E$2)

you could apply it to other cell reference

[tushmen36]

AWESOME! Thank you very much

[vlady]

Your welcome and nice to have you in the community.

Regards,
Vladimir