Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
On Tue, 21 Dec 2004 17:01:02 -0800, pflynn
wrote: I am trying to write a formula in which it can figure the following if a cell is between 91% and 99% then it should multiply by 1.25 if it is not then it should equal 0 =A1*1.25*AND(A10.91,A1<0.99) or, if you are testing A1 to see whether to multiply some other cell (B1) by 1.25: =B1*1.25*AND(A10.91,A1<0.99) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Display numbers only, no text formula | Excel Worksheet Functions |