Prev Previous Post   Next Post Next
  #1   Report Post  
soxn4n04
 
Posts: n/a
Default Help!!!

I'm new to functions and formulas in Excel. I need to write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the result is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1 through 12 is 1


 
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:36 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"