in excel i want to make a IF calc which has a calc as the THEN?

0 ⤊

in snail lingo: if (cellref) = y, then calculate 10% of cellref, otherwise "0"
i used to do this routinely, but have forgotten how:(

2006-06-28 21:14:03 · 2 answers · asked by venturesom 1 in Computers & Internet ➔ Programming & Design

I have used 1 for your y.

=IF(A1=1,A1*10%,0)

2006-06-28 23:23:17 · answer #1 · answered by AnalProgrammer 7 · 0⤊ 0⤋

In Excel
=IF(A1=y,A1*10%,0)

That is your IF here

Read my profile, I am XLMan

2006-07-01 08:37:46 · answer #2 · answered by Anonymous · 0⤊ 0⤋