| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do I create a if-then formula?
I need to create a formula in which if column a is bigger then b, then
subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
|
#2
|
|||
|
|||
|
In C1 enter
=if(A1B1,(A1-B1)*.03,(B1-A1)*.05) You should format it as % "karen" wrote: I need to create a formula in which if column a is bigger then b, then subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
|
#3
|
|||
|
|||
|
=MAX((A1-B1)*3%,(B1-A1)*5%)
Vaya con Dios, Chuck, CABGx3 "karen" wrote in message ... I need to create a formula in which if column a is bigger then b, then subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
|
#4
|
|||
|
|||
|
Very nice
"CLR" wrote: =MAX((A1-B1)*3%,(B1-A1)*5%) Vaya con Dios, Chuck, CABGx3 "karen" wrote in message ... I need to create a formula in which if column a is bigger then b, then subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
|
#5
|
|||
|
|||
|
Thanks for the compliment.............of course it's not an "IF" statement
like the OP requested, but it seemed to be an interesting alternative.......... Vaya con Dios, Chuck, CABGx3 "bj" wrote in message ... Very nice "CLR" wrote: =MAX((A1-B1)*3%,(B1-A1)*5%) Vaya con Dios, Chuck, CABGx3 "karen" wrote in message ... I need to create a formula in which if column a is bigger then b, then subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a if-then formula? | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| Create Formula | Excel Discussion (Misc queries) | |||
| How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Hybrid Mode
