Thread: Question for about using IF formula LEFT function at the same time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jlandes84 jlandes84 is offline
external usenet poster
  
Posts: 7
Default Question for about using IF formula LEFT function at the same time
Can the LEFT text function be used in an IF formula?

For example:

Instead of =IF(F7<G7,"SEA","SF") how would this work?
=IF(F7<G7,"=LEFT(C6,3)","=LEFT(C5,3)")

Instead of getting Sea or San as my result, I get EFT(C6,3)

What am I missing?

Thanks in advance.
Reply With QuoteReply With Quote