| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grater than or less than formula
I am trying to bring back a value to cell L31
if L30 is <$355 then put $30.00 in cell L31 if L30 is or equal to $355 then multiply by 0.085 thank you for any help. using office 2000 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grater than or less than formula
this
=L10+IF(L10=355,L10*0.085,0) or better =L10*IF(L10=355,1.085,0) -- Don Guillett SalesAid Software "Jeff" wrote in message ... I am trying to bring back a value to cell L31 if L30 is <$355 then put $30.00 in cell L31 if L30 is or equal to $355 then multiply by 0.085 thank you for any help. using office 2000 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grater than or less than formula
how do i get the first part to work along with it,
if L30 is <$355 then put $30.00 in cell L31 "Don Guillett" wrote in message ... this =L10+IF(L10=355,L10*0.085,0) or better =L10*IF(L10=355,1.085,0) -- Don Guillett SalesAid Software "Jeff" wrote in message ... I am trying to bring back a value to cell L31 if L30 is <$355 then put $30.00 in cell L31 if L30 is or equal to $355 then multiply by 0.085 thank you for any help. using office 2000 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grater than or less than formula
=if(L30<355,30,L30*.085)
"Jeff" wrote in message ... how do i get the first part to work along with it, if L30 is <$355 then put $30.00 in cell L31 "Don Guillett" wrote in message ... this =L10+IF(L10=355,L10*0.085,0) or better =L10*IF(L10=355,1.085,0) -- Don Guillett SalesAid Software "Jeff" wrote in message ... I am trying to bring back a value to cell L31 if L30 is <$355 then put $30.00 in cell L31 if L30 is or equal to $355 then multiply by 0.085 thank you for any help. using office 2000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help for value grater than 0 placing a name | Excel Discussion (Misc queries) | |||
| Zero values not legend, Value grater then zero show data and legend | Excel Discussion (Misc queries) | |||
| Find value grater than X but less than Y | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
![Jeff[_34_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
