# how can I make an excel formula with condition ?

how can I make an excel formula with condition ?

if age of mother > 64 then 14875 or age of mother < 65 then 13759 in (Class VIP)

if age of mother > 64 then 9633 or age of mother < 65 then 8910 in (Class A)

if age of mother > 64 then 7855 or age of mother < 65 then 7266 in (Class B)

3

• =IF(A1>64,”14875″,”13759″)

Repeat the above formula for your other values. If the long number is to be treated as a number, ignore the quote marks.

00

• Hey spal,

You can do this:

If ([field number] > 64, “14875”, “13759”)

You replace your field number with your actual field number, of course.

Good luck!

Btw, check out my blog here at www.imicrothinking.wordpress.com ! XD My goal in this month is to get a 6 figure page ranking and write 1 entries (pretty sad, I know, spending spare time doing this stuff)…but I’d be eternally grateful if you popped in from time to time and drop in a comment! Thanks !! XD

00

• pseudocode is like =if(and(b1=””,no longer(a1=””)),”AB”, if(and(a1=””,b1=””), “”, “became the guy who wrote this conditional assertion smoking weed because of the fact it is the condition that they left off, interior the actual international, it is an incomplete company requirement”)) use excel help i swear, those instructors arising with those incomplete excel questions…whoever wrote this one…i’m sending to detention. Reasoning, coaching scholars that that’s alright to have incomplete company standards. What relating to the condition the place B1 is nonblank?