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

  • Thread starter Thread starter FennisDuck
  • Start date Start date
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.
 
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
 
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
 
Thanks for the feedback, and for your gratitude - no need to overdo it,
though, as it was only a small amendment <g>

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup function to cell containing multiple values 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Data Validation and drop-down list using IF, AND and what else? 8
Excel formula, sum the value cell and if empty cell left blank 0
Building closed workbook file path within an Index Function 6
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2
How to set cell value to emptry if three other columns are empty too 1
Show other cell if blank 5

Back
Top