Answering a question in a cell

[Guest]

hello all,

I need to answer a question in a particular cell.If value in cell A is <
12% of Cell B how much more is needed to be in cell A to be = or >12 % of
cell b but if cell A is = to or > then 12% cell b leave answer blank.

I thank anyone thank can help me in advance since thi is day one excel for me

 

[Biff]

Hi!

Already answered in your other post that somehow got placed into a
completely unrelated thread:


Hi, Salesmaster. You should ask your question by itself instead of inside
someone elses.
=if(a1<.12,.12-a1,a1)
*******************
~Anne Troy

www.OfficeArticles.com

Biff

 

[moi]

In cel C, try this one:
=IF(B1/A1>=12,B1,(12-A1))