Re: Calling all Excel gurus...A question regarding formulas
Posted 4/3/2012 2:08:38 PM by nrthshgrl


Posted by CSK

I'm not sure if I'm following 100%

You can do this with an "If" function. Choose that from the functions


There may be an easier way, but I would set up each variable as a seperate column

A, B

Then use If function

If B=10 then
True = A*B
Fales =A/B or whatever




I did the reverse.

If B=10, it's true so it would be A1* whatever you want.

=IF(B1:B4=10,A1*NUMBER,A1*B1)

If you want to FM me the exact thing you want to happen when B=10, I can send you the formula
Print Post      Close Window