hello,
I wd like to if with multiple or conditions for attached sample
hello,
I wd like to if with multiple or conditions for attached sample
Maybe this, I not a formula guy. Enter formula in cell F2 and drag down
Formula:Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
little different:
=IF(AND(D2=64,E2>15),3500,CHOOSE(IFNA(MATCH(D2,{128,256,512,2},0),5),5000,5000,5000,10000,0))
pattern is the same
or
=IF(AND(D2=64,E2<15),0,IF(OR(D2=128,D2=256,D2=512),5000,IF(D2=2,10000,3500)))
Last edited by sandy666; 04-23-2017 at 11:49 AM.
thkx a lot for suggestions, it works, one more addition in this, whatever value formulas give i wish to divide it by 365 and multiple by value in C
something like this?
=(IF(AND(D2=64,E2<15),0,IF(OR(D2=128,D2=256,D2=512),5000,IF(D2=2,10000,3500)))/365)*C2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks