test range for entry,new to this !

  • Thread starter Thread starter j.b. miller
  • Start date Start date
J

j.b. miller

Hello. I need help. I'd like to know how to test a range of cells to see if
there is a number in any of them. Then take that number and multiply it by
..07 and save into another cell. I'm trying to create a 'tax paid' column in
a ledger. I've looked for 'ledger templates',tried to use hlookup, all to no
avail. Last time I used a spreadsheet was with Visicalc, so it's been
'awhile' !
Thanks for any help !
Jay
 
Jay

If the original data is in A3, then in the cell you want your 'tax paid'
result

=IF(ISNUMBER(A3),A3*0.07,"")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Hi
one way (assumption: your tesrane ist A1:A100): enter the follwoing in
your target cell
=INDEX(A1:A100,MIN(IF(ISNUMBER(A1:A1100),ROW(A1:A100),999)))*0.07
You have to enter this as array formula (CTRL+SHIFT+ENTER)

If you also want to test for a situation with no numbers in your
testrange use the following array formula
=IF(ISERROR(INDEX(A1:A100,MIN(IF(ISNUMBER(A1:A1100),ROW(A1:A100),999)))
),"",INDEX(A1:A100,MIN(IF(ISNUMBER(A1:A1100),ROW(A1:A100),999)))*0.07)
also entered with CTRL+SHIFT+ENTER
 
Back
Top