Calling all Excel gurus...A question regarding formulas

Posted By Message

HoneyBadger
YourWorstNightmare.

Member since 10/06

15979 total posts

Name:
BahBahBlackJeep

Calling all Excel gurus...A question regarding formulas

Can I set up a conditional formula? For example: I would like to have a*b=c BUT if it's multiplied by ten it will automatically calculate to a different (technically incorrect) answer. Meaning 2*225= 450 but if it's 10*225=2000. Ya dig? Is this possible and if so how do I set up the formula? Thanks :)

Message edited 2012-04-03 13:05:58.677000.

Posted 4/3/12 1:01 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

CSK
LIF Adolescent

Member since 9/11

892 total posts

Name:

Re: Calling all Excel gurus...A question regarding formulas

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

Posted 4/3/12 1:34 PM
 

caps612
In love with my little guys!!

Member since 8/10

5108 total posts

Name:

Re: Calling all Excel gurus...A question regarding formulas

i am not 100% following... but it sounds like you can definitely use an "if" formula

Posted 4/3/12 1:58 PM
 

dlj97
LIF Adult

Member since 7/10

4399 total posts

Name:

Re: Calling all Excel gurus...A question regarding formulas

I am not totally following either, but I don't think there is a way to set up a formula that calculates incorrectly.

Posted 4/3/12 2:03 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Calling all Excel gurus...A question regarding formulas

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

Message edited 2012-04-03 14:09:35.170000.

Posted 4/3/12 2:08 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel gurus (formula question) FelAndJon 7/13/09 4 Families Helping Families ™
Calling LIF lawyers...I have a question sunnyplus3 12/3/07 0 Families Helping Families ™
Calling all HR people, I have a question.... HalloweenBride04 2/13/07 2 Families Helping Families ™
Calling all attorneys-NOT a legal question DRMom 2/9/07 13 Families Helping Families ™
Passport Question...calling Bxgell2 MrsR 9/19/06 27 Parenting
Calling my fellow NJers! Permit Question MrsRbk 7/15/06 3 Home