Ask Your Question
0

Excel Calculating a cell based of the text of another cell

asked 2016-08-14 01:29:00 +0100

Megan gravatar image

I have 2 text values in A7 Auto & Variable, I have a $ value in G7. In H7 If A7 is Auto I want it to copy the value from G7, if A7 is variable I want it to add 10% to the value in G7.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2016-08-14 02:04:49 +0100

mark_t gravatar image

Using a simple IF statement if you don't care if A7 has some other text value.

=IF(A7="Auto",G7,G7*1.1)

Or you could nest the IF function to check both conditions and give some other result if neither is true.

=IF(A7="Auto",G7,IF(A7="Variable",G7*1.1,"Invalid choice"))
edit flag offensive delete link more

Comments

Thank-you, I tried something similar but apparently didn't have it in the right order as I was getting weird amounts. This worked

Megan gravatar imageMegan ( 2016-08-14 02:48:08 +0100 )edit
1

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-08-14 14:27:04 +0100 )edit
0

answered 2016-08-14 16:29:39 +0100

Is this Microsoft products forum? I do not think so.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-14 01:29:00 +0100

Seen: 29 times

Last updated: Aug 14 '16