# Solved: easy excel question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### irvinbang

if i want a cell that i enter footage into ex. 5000' I want it to divide that footage by 250' to give me a total number. Now i want the same formula to tell me if i put over 5000' in the same cell ex. 5001 i want it to divide the footage by 350. and give me that total. Ideas? Thanks for the help in advance.

#### etaf

Wayne
Moderator
did you want the answer in the same cell you type in -
otherwise
assumimg you enter in A1
and result in B1

put this in B1
=If(A1>5000, A1/350, A1/250)

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!