Ask Your Question

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

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.


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


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

If the answer solves your question please tick the ✔.

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

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


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

Seen: 29 times

Last updated: Aug 14 '16