|
If statements
At this time I use the present formula: If (b3 10, 0, b3) If b3 is greater than 10 then enter 0 else enter b3's value What if I wanted to ask the following: If b3 is greater than 10 or = to 10 then 0 else b3 How can this be put into a formula? -- kieffer ------------------------------------------------------------------------ kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
Just amend your formula as follows:
IF (B3 = 10, 0, B3) Hope this helps. Pete |
If statements
=b3*(b3=10) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
If (b3 = 10, 0, b3) If I want to keep the above but add on the following: if(b3 < 10, c3) Can't both of these be combined into 1 formula? -- kieffer ------------------------------------------------------------------------ kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
You can't combine those because they conflict. Your first IF statement says that if B3=10 return 0, otherwise, i.e. if B3<10, return B3 Your second statement says that if B3<10 return C3, you can't return both B3and C3 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
If you are no longer interested in returning 0 but want the contents of c3 if b3 is less than 10 then you can use the following IF(b3=10,b3,c3) -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
if(b39,b3,c3)
-- Don Guillett SalesAid Software "kieffer" wrote in message ... If (b3 = 10, 0, b3) If I want to keep the above but add on the following: if(b3 < 10, c3) Can't both of these be combined into 1 formula? -- kieffer ------------------------------------------------------------------------ kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848 View this thread: http://www.excelforum.com/showthread...hreadid=515131 |
If statements
I am trying to write a statement that compares to cells and assigns a value.
there is a lot of data, and I am not certain that it can be done, any help would be appreciated, ... this is what I am working with ... 70% pay scale: 1 - 500 hrs worked / entry level 80% pay scale: 501 - 1000 hrs worked and 24 hrs or more training courses 90% pay scale: 1001 - 1500 hrs worked and 48 hrs or more training courses 95% pay scale: 1501 - 2000 hrs worked and 48 hrs or more training courses 100% pay scale: 2001 + hrs worked and 72 hrs or more training courses -AC |
| All times are GMT +1. The time now is 11:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com