LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default If, And, Or Formula

Here is my equation:

IF(OR(AND(I3="DG F",I3="DG M"),AND(H3=1,D3="UNK"),ReqPO!AH3,9999),ReqPO!AH 3)

I want to make this statement in the cell K3:

If (I3="DG F" or "DG M" ) and D3="UNK" and H3=0 then I want 9999 in K3.
However if there is a 1 in H3, then I need the ReqPO!AH3 number in K3.
Finally, if D3 = "N/A', then I want a blank cell for K3.

 
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



All times are GMT +1. The time now is 07:39 AM.

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"