format cell formula
I am trying to get this to work...
IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7 IF C8 = 5 or 6 then print 250 in cell M7 I have tried various ways (hopeless at formulas) but can`t get it to work for me. help appreciated thanks |
Hi, Juco;
I didn't see anything in your actual question to do with formatting, but here is one answer to the question: use the IF function with the OR function for its first argument, 200 for its second, and another IF function for its third. Use another OR function for the first argument in the second IF function, 250 for the second, and "" for the third ("" returns blank). So: =IF(OR(C8=1,C8=2,C8=3,C8=4),200,IF(OR(C8=5,C8=6),2 50,"")) Regards, Ian. "Juco" wrote: I am trying to get this to work... IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7 IF C8 = 5 or 6 then print 250 in cell M7 |
Another way:
Enter in M7: =(OR(C8={1,2,3,4})*200+(OR(C8={5,6}))*250) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Juco" wrote in message k... I am trying to get this to work... IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7 IF C8 = 5 or 6 then print 250 in cell M7 I have tried various ways (hopeless at formulas) but can`t get it to work for me. help appreciated thanks |
Thanks for the help,
it works a treat. thank you both Juco "Ragdyer" wrote in message ... Another way: Enter in M7: =(OR(C8={1,2,3,4})*200+(OR(C8={5,6}))*250) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Juco" wrote in message k... I am trying to get this to work... IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7 IF C8 = 5 or 6 then print 250 in cell M7 I have tried various ways (hopeless at formulas) but can`t get it to work for me. help appreciated thanks |
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Juco" wrote in message k... Thanks for the help, it works a treat. thank you both Juco "Ragdyer" wrote in message ... Another way: Enter in M7: =(OR(C8={1,2,3,4})*200+(OR(C8={5,6}))*250) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Juco" wrote in message k... I am trying to get this to work... IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7 IF C8 = 5 or 6 then print 250 in cell M7 I have tried various ways (hopeless at formulas) but can`t get it to work for me. help appreciated thanks |
All times are GMT +1. The time now is 04:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com