| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMAT CELLS
IF CELL B1 = 1 DEVIDE A1 CELL BY .82
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMAT CELLS
In A1:
=IF(B1=1,YourPresentFormula,YourpresentFormula/0.82) Are you sure you mean Divide, not Multiply? -- Kind regards, Niek Otten "Dave Semple" <Dave wrote in message ... IF CELL B1 = 1 DEVIDE A1 CELL BY .82 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMAT CELLS
Of course, the other way around:
=IF(B1=1,YourPresentFormula/0.82,YourpresentFormula) -- Kind regards, Niek Otten "Niek Otten" wrote in message ... In A1: =IF(B1=1,YourPresentFormula,YourpresentFormula/0.82) Are you sure you mean Divide, not Multiply? -- Kind regards, Niek Otten "Dave Semple" <Dave wrote in message ... IF CELL B1 = 1 DEVIDE A1 CELL BY .82 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 format cells to date format | Excel Discussion (Misc queries) | |||
| How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Linear Mode
