PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Tuesday, November 22, 2022

[FIXED] How can we do IF condition in Excel and assign values?

 November 22, 2022     excel, excel-formula, if-statement, logical-operators, multiple-conditions     No comments   

Issue

I want to get a formula for the below conditions:

  1. null | <0.65 then 16

  2. >=1.13 & <2.23 then 8

  3. >=2.23 then 0

I tried:

=If(B3=0,16,IF (B3<0.65,16,IF (B3>=0.65,11,AND (B3<1.13,11,IF (B3>=1.13,8,AND (B3<2.23,8,If(B3>=2.23,0)))))))

Solution

Give a try on below formula-

=IF(OR(B3="",B3=0,B3<0.65),16,IF(AND(B3>=1.13,B3<2.23),8,0))


Answered By - Harun24hr
Answer Checked By - Marie Seifert (PHPFixing Admin)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing