Calling all Excel gurus...A question regarding formulas
| Posted By | Message |
|---|---|
|
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
| |
|
Re: Calling all Excel gurus...A question regarding formulas I'm not sure if I'm following 100% |
|
Posted 4/3/12 1:34 PM
|
|
|
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
|
|
|
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
|
|
|
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 |






