View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrl mrl is offline
external usenet poster
 
Posts: 17
Default Nested IF function

I have the following formula for range of rows in Column F - I want the cell
populated by 1. meeting first condition (formula below) 2. looking at Column
D and returning value in Column F instead of "null" if cell (row) is
populated Column D

Cell F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0))

I had help with this first formula; I really need help now with the second.
--
The generosity of your knowledge is greatly appreciated.