Thread
:
Formula help
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Mike
external usenet poster
Posts: 3,101
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
Reply With Quote
Mike
View Public Profile
Find all posts by Mike