Ms Excel Multiple Logical Test Function

S

sanzuu

Joined
Mar 11, 2013
Messages
1
Reaction score
0
:confused::cry:
Hi...
I would like to automate a spreadsheet using 3 Logical test.

A1 has three diffrent value 1,2 and 3. B1 is function cell which should be as follows
50 if A1 is 1, 500 if A1 is 2 and 5000 if A1 is 3.

What would be the formula?
Please help me..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical formatting for multiple values 1
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Return result of IF logical test in a different cell 1
If Statement with Two Different Logical Test 16
Logical test IF a decimal was typed in a cell 6
How do I write an IF function using dates? 2
function to populate a cell where formula is NOT located 6
Logical Function excel 2003 3

Top