Microsoft Excel for PC Logo
Posted on May 06, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

If formula I need some help with the if function. I am trying to copy a formula into a new cell only if data is entered into another new cell. EX: If C8<0 then copy the formula from G7 to G8

  • Anonymous Mar 29, 2014

    I'm copying formulas but the answers stay the same

×

2 Answers

Anonymous

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 15 Answers
  • Posted on Jun 02, 2008
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

Joined: May 12, 2008
Answers
15
Questions
0
Helped
2621
Points
35

[G8]=IF(C8<0,G7,"")

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Brigadier General:

An expert that has over 10,000 points.

  • Master 3,614 Answers
  • Posted on May 06, 2008
Anonymous
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Brigadier General:

An expert that has over 10,000 points.

Joined: Jan 15, 2008
Answers
3614
Questions
24
Helped
1033831
Points
10054

Use the relative cell reference F4 key..

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

204 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3269 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3869 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...