Thread: IF Formula Help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JonR JonR is offline
external usenet poster
 
Posts: 82
Default IF Formula Help

=IF(D1=TRUE,TRUE,IF(A1=TRUE,IF(B1=TRUE,IF(C1=TRUE, TRUE,FALSE),FALSE),FALSE))

--
HTH

JonR


"Fgbdrum" wrote:

Hi there. Here is my dilemma

Columns
A B C D
Row 1 TRUE FALSE FALSE TRUE

I would like to put a formula in cell E1 that says something to this effect:

If A1 or B1 or C1 equals False, then False. However, if D1 equals True (No
matter what happens in A1, B1, or C1) then True.

Thanks for the help.