Formula help
 

=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the value of 149
E3=3.00 then return the value of 99
E3=5.00 then return the value of 59

Formula help
 

You were nearly there - try this:

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0) )))

Hope this helps.

I'd better go to bed now, otherwise Bob will tell me off <g

Pete

Mike wrote:
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the value of 149
E3=3.00 then return the value of 99
E3=5.00 then return the value of 59

Formula help
 

Hi Pete

I'd better go to bed now, otherwise Bob will tell me off <g
Looks like you got away with it this time, unless Bob isn't awake
yet<bg

--
Regards

Roger Govier


"Pete_UK" wrote in message
ups.com...
You were nearly there - try this:

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0) )))

Hope this helps.

I'd better go to bed now, otherwise Bob will tell me off <g

Pete

Mike wrote:
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the
value of 149
E3=3.00 then return the
value of 99
E3=5.00 then return the
value of 59

Formula help
 

Ha ha - he said he needed a lot of sleep !! I haven't seen a post from
him today, so perhaps he has other things to do rather than admonish
me.

Pete

Roger Govier wrote:
Hi Pete

I'd better go to bed now, otherwise Bob will tell me off <g
Looks like you got away with it this time, unless Bob isn't awake
yet<bg

--
Regards

Roger Govier


"Pete_UK" wrote in message
ups.com...
You were nearly there - try this:

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0) )))

Hope this helps.

I'd better go to bed now, otherwise Bob will tell me off <g

Pete

Mike wrote:
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the
value of 149
E3=3.00 then return the
value of 99
E3=5.00 then return the
value of 59

Formula help
 

Slightly different to what you wanted in .misc

=(300/E3-1)*(OR(E3={1,2,3,5}))


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Mike" wrote in message
...
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the value of
149
E3=3.00 then return the value of
99
E3=5.00 then return the value of
59