Hello! I know this is probably a simple question, but here goes. I have two cells, A1 and B1. A1 has a description in it. B1 has a quantity. I'm trying to create a formula that says if A1 contains "AF" then divide cell B1 by 60. Results to go in cell C1. Is this possible? Thanks, Lance
Last edited by LG1; 01-03-2013 at 08:59 AM. Reason: description
In C1 type:
=IF(A1="AF",B1/60,type what ever you want if the statement is not true here)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
=if(countif(a1:a1,"*af*")>0,b1/60,"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Maybe..in C1
Please Login or Register to view this content.
Last edited by Ace_XL; 01-02-2013 at 02:20 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks Everyone!
LG1,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks