Results 1 to 5 of 5

Thread: New to Excel If statements

Thread Tools
- Show Printable Version
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

Previous Post

Next Post

Oct 27th, 2008, 07:45 AM #1
LostAngel

View Profile

View Forum Posts
Thread Starter
Hyperactive Member

Join Date

Jul 2003

Posts

419
New to Excel If statements

Hey all, I have an excel sheet that pulls data from a database.

How can I get column C cells to have the formula =A<row number>-(B<row number>/10)

IF A and C are not the same value, if they are...I want it to make the formula exclude the /10.
Code:

If LostAngel.Tag = "Programming" then LostAngel.Caption = "Awake" Else LostAngel.Caption = "Dreaming of Code" End If
Reply With Quote

Quick Navigation Office Development Top

« Previous Thread | Next Thread »

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
[VIDEO] code is On
HTML code is Off

Click Here to Expand Forum to Full Width

Terms and Conditions | About Us | Privacy Notice | Contact Us | Advertise | Sitemap| California - Do Not Sell My Info

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

All times are GMT -5. The time now is 01:50 PM.