Hello,
Dear users,
I need your help to create a formula where I can have multiple conditions using IF statement.
See the attached file.
I want a formula like:
Formula:
Please Login or Register to view this content.
I don't know where is the error here.
Thank you for your time.
Regards,
Florian
What are you trying to archive Florian?
Your formula is this =IF(E5>=100%;$F$3;IF(AND(E5>=70%;E5<70%);E5*$F$3;"0"))
and gives 0 as result because both E5 & F3 of your sample sheet are empties..so correctly formula gives you 0 as result..
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
Where's the error and why do you think it is an error?
I guess you're probably getting at D4 onwards, but if you examine the formula you'll see that C4 can't ever be both >=70% AND <70%. Hence this will always fail and since you don't specify a False element in your second IF test you'll always get zero as the answer.
I suspect your formula in D3 copied down should simply be
=IF(C3>=100%,$E$1,C3*$E$1)
but only you can say what answer you are expecting.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
use OR instead of AND
like
=IF(C4>=100%;$E$1;IF(OR(C4>=70%;C4<70%);C4*$E$1;0))
i think its an explanation difficulties.
Click on * below if you find this helpful
Thanks,
A
But by the same token C4 will always be either >=70% OR <70%.Originally Posted by amy_d2
The second IF test is redundant.
that what,.... its my assumption that Kalergi needs in that way in simple ways as below,
if (C4 >=100%,E1,C4*E1)
better he should able tell us his exact requirement ....
Thank you all!
Yes, its an explanation difficulties so, il make it simple.
I have three situations:
1. When C3>= 100% the result must be equal with E1
2. When C3>= 70% the result must be equal with C3*$E1$
3. Wehn C3< 70% the result must be zero.
I apologyze for any inconvenience.
In that case then
Formula:Please Login or Register to view this content.
Yes, it works.
Thank you Richard!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks