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.
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"))
Thank-you, I tried something similar but apparently didn’t have it in the right order as I was getting weird amounts. This worked
If the answer solves your question please tick the .
Is this Microsoft products forum? I do not think so.