is it possible to show a cell value using IF(AND function

F

FennisDuck

I would like to show the value of Cell A1 in Cell A3 , what do I need to
replace "=A1" portion of formula
The cell format is set for numbers and there is also some conditional
formating

Formula contained in cell A3 =IF(AND(A1>0.1,A1<99),"=A1","")
Displays Result as =A1

Thanks in advance all assistance or guidance greatly appreciated.
 
P

Pete_UK

If you put quotes around the value then it is treated as text. Amend
your formula as follows:

=IF(AND(A1>0.1,A1<99),A1,"")

Hope this helps.

Pete
 
F

FennisDuck

Thanks for both replies, you are both the best
worked absolute treat
once again thanks


"If you put quotes around the value then it is treated as text. Amend
your formula as follows:

=IF(AND(A1>0.1,A1<99),A1,"")

Hope this helps.

Pete
 
P

Pete_UK

Thanks for the feedback, and for your gratitude - no need to overdo it,
though, as it was only a small amendment <g>

Pete
 
Top