LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 273
Default Having problems with formula nested tables in Excel

I have the follwing formula in a cell.
=IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs
Assessment. Please have your supervisor review your training needs on the
Employee Training Needs Tab","Proceed in Answering questions 1 through
28")))),"")

When I hit return it does not show the words but only False or nothing.
What am I doing wrong. I am using three true false statements that say.

cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE)

cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE)

cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE)


can anyone help me please

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
I am having problems with a IF(AND(OR nested function Debbie[_2_] Excel Worksheet Functions 2 February 24th 07 04:00 AM
Is anyone having problems with nested subtotaling in XP Excel Wyndhamc01 Excel Discussion (Misc queries) 3 September 14th 06 01:08 PM
Nested If problems BEEJAY Excel Worksheet Functions 7 June 23rd 06 04:47 PM
Problems printing a word document with linked excel tables. jcarlos Excel Discussion (Misc queries) 0 August 30th 05 04:01 PM
Is there some way to pivot nested tables or subtable in excel Shekhar Excel Discussion (Misc queries) 0 June 27th 05 10:35 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"