English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Ok so if i am trying to multiply with an if statement...like this
=IF(A2>5,( ".5"), "")
A2 is greater than 5,so if its greater than 5 then i want to multiply 50% to it.If its not greater than 5 then its blank
( the cell). I am typing in this formula and the cell is blank. What do I do because this formula is wrong. Thanx

2007-01-11 09:34:39 · 2 answers · asked by pinkprincessof09 2 in Computers & Internet Programming & Design

2 answers

The if statement is almost correct... you'll need to 'reference' the cell you are multiplying the 0.5.

for example:

=IF(A2>5,A2*.5,"")

2007-01-11 09:42:44 · answer #1 · answered by ♫ Life is a Highway ♫ 4 · 1 0

you need to put the cell number in for the new data.

2007-01-11 10:16:47 · answer #2 · answered by origamix60 3 · 0 0

fedest.com, questions and answers