Thread: If then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
g g is offline
external usenet poster
  
Posts: 1
Default If then formula
Trying to combine these formulas. Where the then statement would also
contain a specific data label. Is it possible? If so how?

1. =IF(B7*c18<0.5,B7*C18*454,B7*C18)
2. =IF(B7*c18<0.5,"GRAMS","LBS".)

--
G
Reply With QuoteReply With Quote