View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gayla Gayla is offline
external usenet poster
 
Posts: 30
Default Nested Formula - HELP

Here are the formulas I am trying to put together into one formula but cannot
seem to get it right.

IF((AND($I$5="",$J$5="") IF TRUE THEN DO THE FOLLOWING CALCULATION:

SEE IF ONE OF THE FOLLOWING APPLY:
OR($G$5=K3,$G$5<=K2),1,""), OR($H$5=K3,$H$5<=K2),1,"")

IF FALSE DO THE FOLLOWING:

SEE IF ONE OF THE FOLLOWING APPLY:
OR($I$5=T3,$I$5<=K2),1,""), OR($J$5=K3,$J$5<=K2),1,"")

Any help will be appreciated.