Lookup function
 

Hi all,
This is driving me crazy. I am trying to make up this formula
=IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2 from
20.72 and total)
Then if E2 = 2 and G2 is 41.44 or less its "ok". If over 20.72 subtract G2
from 41.44 and total)
I have 15 numbers to do this way .

Any help will really be appreciated.



I am new to this an am not sure what I need to show you

Lookup function
 

Hi Mary,

This may get you going. But I don't know what you mean by...

...subtract G2 from 20.72 and total)

Total what?

=IF(AND(E2=1,G2<=20.72),"OK",G2-20.72)

HTH
Regards,m
Howard

"Mary" wrote in message
...
Hi all,
This is driving me crazy. I am trying to make up this formula
=IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2 from
20.72 and total)
Then if E2 = 2 and G2 is 41.44 or less its "ok". If over 20.72 subtract G2
from 41.44 and total)
I have 15 numbers to do this way .

Any help will really be appreciated.



I am new to this an am not sure what I need to show you

Lookup function
 

I'm not sure what you are trying to achieve, do you want 15 IF functions
in one or seperate formulae like =IF(AND(E2=1,G2=20.72),"OK",G2-20.72)
?

Mary;276730 Wrote:
Hi all,
This is driving me crazy. I am trying to make up this formula
=IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2
from
20.72 and total)
Then if E2 = 2 and G2 is 41.44 or less its "ok". If over 20.72 subtract
G2
from 41.44 and total)
I have 15 numbers to do this way .

Any help will really be appreciated.



I am new to this an am not sure what I need to show you


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77294