| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create If then statements
I am looking to create an if then statement to create an equation
If b5 is greater than or equal to B17; then b5*f1 If b5 is less than b17 then b5*f2 Can anyone help me form this into an excel cell to calculate? Thank you Julie Niedfeldt |
|
#2
|
|||
|
|||
|
Try this:
=IF(B5<B17,B5*F2,B5*F1) HTH, Paul "Jniedfeldt" wrote in message ... I am looking to create an if then statement to create an equation If b5 is greater than or equal to B17; then b5*f1 If b5 is less than b17 then b5*f2 Can anyone help me form this into an excel cell to calculate? Thank you Julie Niedfeldt |
|
#3
|
|||
|
|||
|
Hi Julie
A straight If formula should do that: =if(B5=B17,B5*F1,B5*F2) IF (condition, condition true, condition false) Best regds Chris Lav "Jniedfeldt" wrote in message ... I am looking to create an if then statement to create an equation If b5 is greater than or equal to B17; then b5*f1 If b5 is less than b17 then b5*f2 Can anyone help me form this into an excel cell to calculate? Thank you Julie Niedfeldt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| Template in Excel | New Users to Excel | |||
| trying to create | Excel Discussion (Misc queries) | |||
Linear Mode
