ExcelBanter - cell value<presented value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell value<presented value (https://www.excelbanter.com/excel-worksheet-functions/116998-cell-value-presented-value.html)

Nir

cell value<presented value

Hi,
I want that if simple condition is true then cell will present value A but
will keep behind value B. Is that possible?
thanks

Bernie Deitrick

cell value<presented value

Nir,

No. You need to use two cells to have two usable values. You can use conditional formuals (think
IF functions) to show which of the values you want...

HTH,
Bernie
MS Excel MVP

"Nir" wrote in message
...
Hi,
I want that if simple condition is true then cell will present value A but
will keep behind value B. Is that possible?
thanks

All times are GMT +1. The time now is 04:52 PM.