Using > and < in Excel [Closed]

Question

Using > and < in Excel [Closed]

Report

Punky - Dec 3, 2010 at 03:46 PM
RayH - Dec 3, 2010 at 07:14 PM

Hey,

I am trying to apply a couple of options in Excel and i am having some trouble using IF & AND etc...

Basically I have Cell C12, in which I will input a number(eg.1000) and If the value is <(less than) 1524 then i want 0.04 to appear in Cell C13, But if the value is >(more than) 1523 i want 0.043 to appear in Cell C13.

So Cell 13 value can change.

Any Ideas???

DAN

Using > and < in Excel
Transfer data from one excel worksheet to another automatically - How-To - Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Excel @ in formula ✓ - Forum - Excel
Number to words in excel without vba ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software

1 reply

Ask a question

RayH · Answer 1 · 2010-12-03T19:14:25-0500

Answer 1 / 1

RayH
Dec 3, 2010 at 07:14 PM

=IF(C12<1524,0.04,IF(C12>1523,0.043))

Using > and < in Excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!