LinkBack URL
About LinkBacks
how do you use a formula showing a value on G4 and I4 based on amount of H4
the condition are:
if H4=1, G4=10, I4=100
if H4=2, G4=20, I4=100
if H4=3, G4=30, I4=300
if H4=4, G4=40, I4=300
if H4=5, G4=50, I4=300
the formula will be on G and I column
how do you use a formula showing a value on G4 and I4 based on amount of H4
the condition are:
if H4=1, G4=10, I4=100
if H4=2, G4=20, I4=100
if H4=3, G4=30, I4=300
if H4=4, G4=40, I4=300
if H4=5, G4=50, I4=300
the formula will be on G and I column
Last edited by k1dr0ck; 11-08-2017 at 05:08 AM.
Is it real data?
G4=H4*10
I4=IF(H4<3,1,3)*100
Quang PT
its just a dummy data
i just want to know the formula for multiple if condition
to OP sometimes its better nit to nest IF functions if that is what you are attempting. formals can get very out of hand fast. often there is a better solution if you can provide a sample we might be able to help more efficiently.
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
If h4=145.30, g4=440.00, i4=10.00
if h4=163.50, g4=495.00, i4=10.00
if h4=181.70, g4=550.00, i4=30.00
if h4=199.80, g4=605.00, i4=30.00
if h4=218.00, g4=660.00, i4=30.00
you would be better to have a table with the vales set up then index and match or vlook the data imo
maybe something like this
i see thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks