| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I write a formula: if (cell address) is less than X add Y
HI
Cell one is A1 Cell Two is B1 Formula in Cell three =if(B1=7.5, SUM(A1:B1), A1+7.5) -- Cillian "CTrophyMan" wrote: I am using Excel 2003 and I want to write a formula to add 2 cells with a condition that is the second cell value is less than a preset amount, i.e. $7.50 then add the preset amount instead of the value in the second cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell address of occurence of a vlookup formula | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
