use the IF() function, if(logic, true, false) eg =if(C1=10, B2+C2, B3+C3)
it's like if c1=10, then B2+C2, else B3+C3
or you can do multiple loop/condition inside eg =if(if(if(......) ) )
Microsoft Excel formulae....... How to do this?
|
|
 May 2 2008, 10:13 PM
Return to original view | Post
#1
|
 
Junior Member
336 posts Joined: Dec 2004  
|
|
Quote
| Change to: |  0.0140sec
 0.82
 6 queries
 GZIP Disabled
Time is now: 11th December 2025 - 01:26 AM |
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Powered by Invision Power Board © 2025 IPS, Inc.