LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 361
Default Combining IF's


I am trying to combine these IF statements. Can't seem to get it to work.

if q11="A" then 0

if q11="OK" and k11="Buy" then (N11-M11)*L11*100) otherwise
(M11-O11)*L11*100)

if q110 and k11="Buy" then (N11-r11)*L11*100) otherwise
(r11-O11)*L11*100)


if none of these conditions exist, "Check"


Thank You In Advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining subtotal and sumif functions TPDigg Excel Worksheet Functions 3 November 15th 06 04:52 PM
Combining data from two columns PCLIVE Excel Discussion (Misc queries) 0 August 2nd 06 08:10 PM
Combining COUNTIF and AND functions david Excel Worksheet Functions 16 July 7th 06 02:55 AM
Sorting & Combining Rows LaNaye Excel Discussion (Misc queries) 3 January 12th 06 02:14 PM
Combining text from multiple columns into 1 stelee Excel Discussion (Misc queries) 3 July 6th 05 11:04 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"