FORMAT CELLS
 

IF CELL B1 = 1 DEVIDE A1 CELL BY .82

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

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