[SOLVED] FormulaR1C1 in Case statement?

[uberathlete]

Hello everyone

I have the following code:

Please Login or Register  to view this content.

This assigns a static formula (=$Q$1) to each cell in column C (starting in C2) if the cell in column A has "John".

However, say I want instead for the formula to pick up a value in column B. So C2 would have the formula =B2*$Q$1 , C3 would be =B3*$Q$1, C4 would be =B4*$Q$1 , and so on , is there a way to modify the code to do this?

Any help would be much appreciated!

[MickG]

Try:-

Please Login or Register  to view this content.

[uberathlete]

Thank you for your reply MickG. This gives the correct end result, but the formula shows the actual value.

Can that be modified so that the cell reference shows? So instead of =Actual value in B*$Q$1$ , it will say =B(x)*$Q$1 instead?

[mikerickson]

How about

Please Login or Register  to view this content.