| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need HELP with simple excel formula!
I'm trying to come up with a basic formula today!
I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need HELP with simple excel formula!
Try
=IF(A11,A1*B2,A1*B1) Mike "Danni2008" wrote: I'm trying to come up with a basic formula today! I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need HELP with simple excel formula!
Basic formula with no error trapping..............
=IF(A11,A1*B2,A1*B1) Gord Dibben MS Excel MVP On Tue, 1 Jan 2008 11:46:00 -0800, Danni2008 wrote: I'm trying to come up with a basic formula today! I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need HELP with simple excel formula!
THANK YOU SO MUCH, IT WORKED!
"Mike H" wrote: Try =IF(A11,A1*B2,A1*B1) Mike "Danni2008" wrote: I'm trying to come up with a basic formula today! I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need HELP with simple excel formula!
THANKS, THAT WORKS!! D
"Gord Dibben" wrote: Basic formula with no error trapping.............. =IF(A11,A1*B2,A1*B1) Gord Dibben MS Excel MVP On Tue, 1 Jan 2008 11:46:00 -0800, Danni2008 wrote: I'm trying to come up with a basic formula today! I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need HELP with simple excel formula!
Interesting... both Mike and Gord opted to perform the multiplication inside
the true and false conditions of the IF function. Since the value being multiplied is the same (A1), my preference would be to multiple it by the result of the IF statement... =A1*IF(A11,B2,B1) Rick "Danni2008" wrote in message ... I'm trying to come up with a basic formula today! I want to find how to write a formula where I want to basically find out: if A1 is 1, then multiply by cell B2 - otherwise (if not true), multiple by cell B1) Any help? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| simple excel formula | Excel Discussion (Misc queries) | |||
| Simple Excel Formula Help | New Users to Excel | |||
| Help with what I believe is a simple excel formula!!!!!!! | Excel Discussion (Misc queries) | |||
Linear Mode
