Type a value in a cell based on another cell
Closed
Concorde
-
Aug 4, 2016 at 04:12 AM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 6, 2016 at 07:19 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 6, 2016 at 07:19 PM
Related:
- Excel typing in one cell appears in another
- How to type # in laptop - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- Typing master 11 mod apk - Download - Education
- Marksheet in excel - Guide
1 response
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Aug 6, 2016 at 07:19 PM
Aug 6, 2016 at 07:19 PM
Why do you need VBA for this? Here is a regular formula...
=IF(A1>3,"",IF(A1=3,5,IF(A1>2.4,10,15)))
(also, if you are using real numbers, don't wrap them in :: it makes them text)
=IF(A1>3,"",IF(A1=3,5,IF(A1>2.4,10,15)))
(also, if you are using real numbers, don't wrap them in :: it makes them text)