Urgent excel help needed.

  Lisa Ruth 21:47 15 Jan 2019
Locked

Is there an IF statement that will calculate something based on a text entry.

A1 = value A2 = true / false A3 = 'if A2 = true then = A1 + 20%, if false then = A1

  Taff™ 08:28 16 Jan 2019

I would create A4 IF a2 = True it returns -20%

Then amend your original A3 cell to be = SUM (A1*A4)

Head the fourth column Discount maybe

Get the gist?

Where's VOG when you need him LOL

  wiganken2 09:55 16 Jan 2019

Have you tried Microsoft Office Forum? click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Call of Duty: Modern Warfare preview

Nexus Studios on how to make the perfect animation showreel and portfolio

Apple TV streaming service: what, where, when and how much

Apple Watch Series 5 : date de sortie, prix et autres rumeurs