Thread: Project If Function
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by sarajmen View Post
Hi there,

please I need a help. SELLING PRICE (H3) is equal to = IF THE (B3 = L1 ENTER (M1), or if B3 = (L2) ENTER (M2), IF (B3) does not contain (L1 or L2) THEN (E3) multiplied by (G3) PLUS H2)

thanks
Try this in cell H3 and copy down.

=IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))

Is that what you mean?
Last edited by Spencer101 : September 24th 12 at 09:47 AM Reason: EDIT: Amended typo in formula.
Reply With QuoteReply With Quote