Thread: Help with nested if/or statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nick nick is offline
external usenet poster
  
Posts: 192
Default Help with nested if/or statements
Hi,
I'm trying to construct a formula that does the following
=IF(AND(OR(ISTEXT(Sheet3!$A$28),ISNUMBER(Sheet3!$A $28))),OR(ISTEXT(Sheet3!A$30),ISNUMBER(Sheet3!A$30 ),Sheet3!C30,Sheet3!C28),Sheet3!C25)

In plain talk, if there is text or numbers in A28, check if there is text or
numbers in A30, if no in the first IF use c25, if no in the second arguement
use c28, if yes for both use c30

Any ideas?
Reply With QuoteReply With Quote