| x404.co.uk http://www.x404.co.uk/forum/ |
|
| Excel help http://www.x404.co.uk/forum/viewtopic.php?f=3&t=16288 |
Page 1 of 1 |
| Author: | l3v1ck [ Tue Apr 17, 2012 1:15 am ] |
| Post subject: | Excel help |
Can anyone offer any advice on the formula I need to use to do this: I want a formula that says "If the sum of cells T22:T27 is 6, then 1, if not then 0 ". I can't find any way of doing that without creating and extra row with the total of T22:T27, then saying "is the number in T28 6?" I really don't want to do that if at all possible. If that's not possible, is there a way of saying "If the letter in cell D28 is Y, then 1, if not then 0". Thanks in advance. |
|
| Author: | Fogmeister [ Tue Apr 17, 2012 1:36 am ] |
| Post subject: | Excel help |
Should be able to do... =if(sum(t22:t27)=6,1,0) That should work. HTH --- I am here: http://tapatalk.com/map.php?m1z3pl |
|
| Author: | l3v1ck [ Tue Apr 17, 2012 1:47 am ] |
| Post subject: | Re: Excel help |
Thanks, I'll give it a try. |
|
| Author: | l3v1ck [ Tue Apr 17, 2012 1:49 am ] |
| Post subject: | Re: Excel help |
That works perfectly. Thanks for the help. |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|