Posted to microsoft.public.excel.worksheet.functions

mrl

external usenet poster

Posts: 17

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested IF function???	[email protected]	Excel Worksheet Functions	2	September 25th 07 09:27 AM
Nested And function	Kelvin Pek	Excel Worksheet Functions	3	August 2nd 06 11:31 AM
can you nested sum and round function within if function?	anna	Excel Worksheet Functions	4	May 27th 06 06:06 AM
Offset function with nested match function not finding host ss.	MKunert	Excel Worksheet Functions	1	March 21st 06 10:46 PM
Nested IF Function, Date Comparing, and NetworkDays Function	carl	Excel Worksheet Functions	2	December 29th 04 09:57 PM

All times are GMT +1. The time now is 09:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us